Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The following is the business environment of Enterprise Car Rental. A car is manufactured by one manufacturer only. A manufacturer manufactured at least one of

The following is the business environment of Enterprise Car Rental. A car is manufactured by one manufacturer only. A manufacturer manufactured at least one of Enterprise's cars. A car could have had many maintenance events (but a brand-new car may not have had any, yet.) A car may not have been rented to any customers (again, the case of a brand-new car) or to many customers. A customer may have rented many cars from Enterprise, and to be in Enterprise's business environment must have rented at least one.

Please draw the ERD for the above business using Crow's Foot notation. Include any and all attributes you think are required. If you are making any assumptions, do mention them explicitly.

Grading Criteria (partial marking will be there):

10 points if it has all entities

15 points for all correct relationships

7 points to all correct primary keys

5 points for all foreign keys

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

Databases Illuminated

Authors: Catherine M. Ricardo

1st Edition

0763733148, 978-0763733148

More Books

Students also viewed these Databases questions

Question

=+How many children do you have?

Answered: 1 week ago