Question
Design an E/R diagram to model the following information about cars, rental agencies, and drivers. Drivers reserve cars from rental agencies. A car is uniquely
Design an E/R diagram to model the following information about cars, rental agencies, and drivers. Drivers reserve cars from rental agencies. A car is uniquely distinguished by its VIN number, and has a model name and color. A rental agency is uniquely distinguished by its name, and has an address. A driver is uniquely distinguished by his/her SSN, and has a name, address, license registration number, and age. A driver can reserve any number of cars, and each of these cars could be reserved through different rental agencies. Any given car is rented through a unique rental agency (which presumably owns the car). Every reservation is for a unique car, handled by a unique rental agency, and can list up to 10 (designated) drivers. However, a reservation must have at least one driver.
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