Question: You have a summer service learning job in database development helping community businesses keep track of their data. You are assigned to work for the
You have a summer service learning job in database development helping community businesses keep track of their data.
You are assigned to work for the the Alfie's Car Rentals. As a first task, you have been asked to create an entity relationship model for their new rental system.
Some "business rules"facts pertaining to Alfie's Car Rentals operations are outlined below. These facts define the requirements which the Database must meet.
Customers rent cars.
Customers sign a contract for the car rental when they arrive to pick up car assigned to them.
Alfie's Car Rentals has five different models of cars.
The daily rate that is charged to the customer depends on the model of car.
Identify all the entity classes tables and create an entity relationship model ER diagram Identify the type of relationships between the entities.
For each entity class that you have included in the model, provide a sample list of attributes for which data might be collected. Identify all primary and foreign keys.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
