Question
A car rental company wants to digitalize the management process. The company has a number of vehicles which are characterized by id, license plate, model,
A car rental company wants to digitalize the management process. The company has a number of vehicles which are characterized by id, license plate, model, year of production, maximum number of preloaders, type of engine, type pf gearbox, as well as the current number of kilometers of the vehicle. Every vehicle is insured with an insurance company. Depending on prices and offers that insurance companies dispose of vehicles can be insured by different companies. For each vehicle the company has to list of insurances in years which is characterized by the name of the company, insurance, start date, end date and insurance cost. Customers who want to rent a vehicle must register with the system. Information that customers must provide are: name, surname, date of birth, personal identification number, email, and phone number. For each lease, the company maintains date, time and place of withdrawals from the customer, date, time and place of delivery of the vehicle. Among other things, notes on the state of the vehicle in the delivery or withdraw moments can be saved. Draw the ER Diagram Crows Foot ERD
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