Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You will be modelling rental car booking database. You dont need to model every aspect of such an application. Do not try to simulate a

You will be modelling rental car booking database. You dont need to model every aspect of such an application. Do not try to simulate a transaction, ordering process or payment process. The database would record information about customers, locations, cars. Who rent a car from which location. It also record payment method a customer have (not how to pay a rental car), feedback given to rental location and some rental details. You only need to model the following, create necessary attributes (or Entities) as you see fit: Pickup locations There are rental car locations where customers can pick up the rental cars. More specifically, a customer may pick up cars from multiple locations over the years. Customers Customers who rent cars Cars Each rental pickup location can have various kinds of cars. They may have multiple cars of the same type, e.g. multiple Honda Civics. I would suggest using this entity set to store car information/description such as brand, model, manufacture etc. not to store VIN or license plate number etc. Customers can write feedback about the service of a pickup location. The Customers register their payment methods (e.g. credit card which has credit card name, credit card number and credit card expiration date). Again, we do not model transactions in this exercise. You need to model what cars a pickup location rents. Hint: This may be implemented as a many-to-many relationship between locations and cars. You need to model the pickup date, price, etc. Hint: This may be implemented as a many-to-many relationship between customers and locations. Make sure that each entity has an appropriate set of attributes and that you also model the relationship between your entities. The diagram needs to be drawn in Erdplus.com and save as an image file. Upload your image file to blackboard. 1. The entities, attributes and relationships need to meet the requirements listed above. 2. Your diagram should include indications regarding the multiplicity of the relationships in your model. 3. An explanation of many-one relationships if any in the diagram. 4. Refer to the grading rubrics associated with the assignment.

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

Question How are IRAs treated for state tax law purposes?

Answered: 1 week ago