Question: 3. Your task is to design a database for a dealership that sells and rents cars. Consider the following in your design: Each car has

 3. Your task is to design a database for a dealership

3. Your task is to design a database for a dealership that sells and rents cars. Consider the following in your design: Each car has a unique ID, brand, model, color, rental rate category, and selling price. - Customers can be either registered or unregistered. A customer has a unique ID, name, and date of birth. Registered customers additionally have telephone number(s), driver's license number, and loyalty points. - All customers can buy cars. For every purchase, you need to register the purchase date, and credit card details (including card number, expiry date, and security code). - Only registered customers can rent a car. For every rental, you need to keep the rental date and the return date. A registered customer can rent five cars maximum at the same time. Draw the corresponding E-R diagram, using Chen notations, to match the listed information of this dealership's requirements

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!