Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

3. What can we do with what we see or hear?

Answered: 1 week ago

Question

Convet the following EBNF to BNF S---> A{bA} A---> a[b]A

Answered: 1 week ago

Question

1. What is called precipitation?

Answered: 1 week ago

Question

1.what is dew ?

Answered: 1 week ago

Question

1.The difference between climate and weather?

Answered: 1 week ago

Question

1. What is Fog ?

Answered: 1 week ago

Question

How water vapour forms ?

Answered: 1 week ago