Question: Need help answering this for an assignment in my data-base driven website class. You will be modelling rental car booking database. You don't need to

Need help answering this for an assignment in my data-base driven website class.

Need help answering this for an assignment in my data-base driven website

You will be modelling rental car booking database. You don't need to model every aspect of such an application. 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. 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. Each car has particular attributes (brand, manufacture, model, etc.). A kind of car may be picked up from multiple different locations. 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) You need to model what cars a pickup location rent and how many You need to model the pickup date, price, etc. . . 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. The entities, attributes and relationships need to meet the requirements listed above. Your diagram should include indications regarding the multiplicity of the relationships in your model. An explanation of many-one relationships if any in the diagram. Refer to the grading rubrics associated with the assignment. 1. 2. 3. 4

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!