Please make sure the primary keys, foreign keys are mentioned clearly. Any ambiguity could lead to you losing points.

Question 1: (40 points)

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. Include any and all attributes you think are required such as Customer Details, etc.

Convert the ERD to tables and convert the ERD into tables based on the rules discussed in class.

Note: If you are making any assumptions, do mention them explicitly.