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.

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
Get step-by-step solutions from verified subject matter experts
