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 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
Get step-by-step solutions from verified subject matter experts
