Create an E-R model with entities, attributes, identifiers, and relationships to provide data storage that accommodates the
Question:
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 keep track of different types of cars and customers in MS Excel, but this has become difficult to maintain. We want to create a database to help integrate this data and assist with reporting. First, we must keep track of our customers, including the contact's name, phone number, and billing address. We also need an inventory of our cars' fleet, including details of cars, including the type of car, model, and price per model. We need to be able to schedule car rentals by date and allow clients to pick up and drop off. 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 An Adobe Acrobat (PDF) document with file name: ErdAssignment1_LastName_FirstName.pdf. Where LastName is your last name as it appears in CUNY First and FirstName is your first name as it appears in CUNY First. 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. Please do not try and crowd everything on one page.
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi