Create an Entity Relationship model for a business case and then convert the model to a set of relations.

1) Read through the following business case for the Car Rental Company.

2) Create an E-R model with entities, attributes, identifiers and relationships to provide data storage that accommodates the description of the company. a. All relationships should be labeled with verb phrases. b. Use UML notation for this work. Please review the UML videos, as well as the lucid chart videos provided. c. Relationship lines should be straight and should not cross.

3) Write out a list of Relationship Sentences for each relationship.

One may be (or must be) one (or many)

We operate a small but growing Car rental company in Westchester, New York. We have 50 cars and 300 customers. We have two locations, one at airport and one in Yonkers. Currently we keep track of different types of cars and customers in MS Excel but this has become difficult to maintain. We are looking to create a database to help integrate this data and to assist with reporting. First, we need to keep track of our customers including the name and phone number of the contact along with the billing address. We also need an inventory to our cars fleet, including details of cars including the type of car, model, price per model. We need to be able to schedule cars rentals by date and allow clients to pick up and drop off in our two locations. Finally, we need to keep track of each car rental starting date and time, as well as the return date and time. We also need to accept and record clients payments per rental. A car can only be rented by one client at a time. At the end of each month we will have a rental report to show rental amounts per car type.

Project Deliverables - What you will upload to Blackboard

This single file will contain:

1) Cover page with your name, course name and course section

2) E-R model drawn using UML notation showing entities, attributes, identifiers and relationships

3) A page with the relationship sentences 4) A page with the initial set of relations created from the ER model.