Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create Entity Relationship Diagrams (ERDs) for The Fitness company's rental point-of-sales (POS) system. Here is the transcript of the information from the business owner: We

Create Entity Relationship Diagrams (ERDs) for The Fitness company's rental point-of-sales (POS) system. Here is the transcript of the information from the business owner:

We want to automate the rental system to handle renting and returning processes, billing, and replacing old equipment. Currently, we have two types of customers: regular customers, who pay a monthly membership premium, and one-off renters. Our customers are mainly business offices and resident buildings. Occasionally, we have one-off home owners who rent for a month or so just to try out our equipment. We didnt keep track of the one-off renters in the past, but we want to start doing so to send them future promotions by email or phone.

On our future system, customers can book an equipment in advance by themselves if they have an account with us. They would specify the dates they want to rent, the pick-up location, and promotion code if any. If theyve used our services in the past, they must have a zero balance to make a new request. If they have been flagged because of late payments or having caused damage, we can reject their request for expensive items. Equipment are checked against a master schedule of availability and rates are calculated, including discounts. Customers can pay by credit card.

We do not offer currently offer delivery, so customers must come to the store to pick up the equipment. We have three locations in Area 1, 2 and 3. Our staff confirm their ID and booking before giving them the equipment. When a customer returns the equipment, it is checked for any damage, and a bill is calculated with a damage charge. If the equipment is not returned on time, there is a 10% fee after the first 48 hours. Our staff will try to contact the customer. If there is no response, the equipment is reported as stolen and we charge the lost equipment fees to the customers credit card. After two years, or when there is a serious damage, old equipment is replaced."

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advances In Databases 28th British National Conference On Databases Bncod 28 Manchester Uk July 2011 Revised Selected Papers Lncs 7051

Authors: Alvaro A.A. Fernandes ,Alasdair J.G. Gray ,Khalid Belhajjame

2011th Edition

3642245765, 978-3642245763

More Books

Students also viewed these Databases questions