Problem
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 several 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:
a) Corresponding set of tables. No SQL is needed for this assignment. Only provide tables including attributes for each entity and relationship.
b) Each table should have primary key and foreign key (if needed for relationship).