Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started