Description: The car rental company allows customers to reserve rental cars over the internet, the company also allows customers to rent cars by calling up car rental personnel or by walking up to the rental counter.
The rental car company has a number of branches and each car is assigned to a home branch. Cars are always rented from the home branch but may be returned to a different branch. Cars are sometimes shifted from location to location – i.e. the home branch location of a given car can be changed.
The company offers various types of cars and various price plans. Cars are grouped into the following classes: Subcompact, Compact, Midsized, Full sized, Luxury. Pricing varies by class of car, duration of rental. The company periodically offers special deals, e.g. one week rental of midsized car for $150. The company also offers discounts for organizational memberships, e.g. AAA, AARP. There is a separate set of fees when a car is not returned to the car’s home branch – this fee will depend on the identity of the home branch and the branch to which the car is returned, e.g. the fee might depend on the distance between the home branch and the return location.
We assume that a customer must register before he or she rents a car. Once the customer is registered, the registration data stays in the system.
Provide:
1. A detailed schema using the ER model including: (50 points)
• Design a corresponding set of tables that are in at least 3NF. (25 points)
• List of the attributes for each entity and relationship. (15 points)
• Explanations of the non-obvious entities and relationships. (10 points)
Please find the ER Diagram below. I have prepared in detail so that you get the relationship and attributes in same place.
Non obvious entities are those which can have null values in the table. This can be like special offer, total return fees etc in the booking table. Those fields can be null as because customer did not get any offer and returned the car at the home branch only.
Thanks.
Description: The car rental company allows customers to reserve rental cars over the internet, the company...
Bargain Rental Car offers rental cars in an off-airport location near a major tourist destination in California. Management would like to better understand the variable and fixed portions of its car washing costs. The company operates its own car wash facility in which each rental car that is returned is thoroughly cleaned before being released for rental to another customer. Management believes that the variable portion of its car washing costs relates to the number of rental returns. Accordingly, the...
Bargain Rental Car offers rental cars in an off-airport location near a major tourist destination in California. Management would like to better understand the behavior of the company’s costs. One of those costs is the cost of washing cars. The company operates its own car wash facility in which each rental car that is returned is thoroughly cleaned before being released for rental to another customer. Management believes that the costs of operating the car wash should be related to...
Bargain Rental Car offers rental cars in an off-airport location near a major tourist destination in California. Management would like to better understand the variable and fixed portions of it car washing costs. The company operates its own car wash facility in which each rental car that is returned is thoroughly cleaned before being released for rental to another customer. Management believes that the variable portion of its car washing costs relates to the number of rental returns. Accordingly, the...
Bargain Rental Car offers rental cars in an off-airport location near a major tourist destination in California. Management would like to better understand the variable and fixed portions of it car washing costs. The company operates its own car wash facility in which each rental car that is returned is thoroughly cleaned before being released for rental to another customer. Management believes that the variable portion of its car washing costs relates to the number of rental returns. Accordingly, the...
Bargain Rental Car offers rental cars in an off-airport location near a major tourist destination in California. Management would like to better understand the variable and fixed portions of it car washing costs. The company operates its own car wash facility in which each rental car that is returned is thoroughly cleaned before being released for rental to another customer. Management believes that the variable portion of its car washing costs relates to the number of rental returns. Accordingly, the...
Bargain Rental Car offers rental cars in an off-airport location near a major tourist destination in California. Management would like to better understand the variable and fixed portions of it car washing costs. The company operates its own car wash facility in which each rental car that is returned is thoroughly cleaned before being released for rental to another customer. Management believes that the variable portion of its car washing costs relates to the number of rental returns. Accordingly, the...
Bargain Rental Car offers rental cars in an off-airport location near a major tourist destination in California. Management would like to better understand the variable and fixed portions of it car washing costs. The company operates its own car wash facility in which each rental car that is returned is thoroughly cleaned before being released for rental to another customer. Management believes that the variable portion of its car washing costs relates to the number of rental returns. Accordingly, the...
Bargain Rental Car offers rental cars in an off-airport location near a major tourist destination in California. Management would like to better understand the variable and fixed portions of it car washing costs. The company operates its own car wash facility in which each rental car that is returned is thoroughly cleaned before being released for rental to another customer. Management believes that the variable portion of its car washing costs relates to the number of rental returns. Accordingly, the...
Bargain Rental Car offers rental cars in an off-airport location near a major tourist destination in California. Management would like to better understand the variable and fixed portions of it car washing costs. The company operates its own car wash facility in which each rental car that is returned is thoroughly cleaned before being released for rental to another customer. Management believes that the variable portion of its car washing costs relates to the number of rental returns. Accordingly, the...
Management Informtion Systems. Question: create a flow chart from the scenario below: -I am starting up a local car rental company. With this system a Customer can rent a car from me based on the car’s make and model. This system provides customer to have different pick-up and drop-off locations and will impose late fee if the rental car is returned beyond the return date and time. The Customers can purchase car rental insurance which is optional and can use...