UTK Rent-a-Car Department wishes to implement a database to control all aspects of its operations, including tracking car inventories, rental contracts, and billing. The following statements of business rules and relationships are used to construct an ERD model:

(a) A model is defined as a specific manufacturer, model type, and year (e.g., 2007 Honda Accord). Each model is a member of one and only one car class (compact, standard, or full size). A class has many models.

(b) A model is associated with one or more cars.

(c) Cars are assigned to locations, and each location has one or more cars.

(d) A customer who wants to rent a car makes a reservation. The reservation is made for pickup of a particular class of car at a specific location. The same customer may make more than one reservation over time.

(e) In the normal course of events. a reservation results in a rental agreement, which is established when the customer comes to the location to pick up the car. However, this is not always the case, since a reservation may be canceled or the customer with a reservation may not show up.

(f) A rental agreement is for a specific vehicle. At any point in time, a specific vehicle may have participated in zero, one, or more rental agreements.

Requirements:

(1) Construct an ERD based on the preceding statements.

(2) The following discussion of the reservation process will help you identify some attributes. Assign the attributes to the appropriate entities. Indicate primary key and foreign key attributes.

Car rental rates are determined by the class of the car. UTK Rent-a-Car has two rental rates for each class: daily and weekly. The car model includes a make (Ford, Honda, etc.), the year of the model, and the model name. Each car is uniquely identified by a vehicle identification number (VIN). The branch to which the vehicle is assigned has an address and a location ID.

The process of renting a car is as follows. Typically, a customer first makes a reservation with a location by telephone prior to arriving at the branch location to pick up the car. The UTK Rent-a-Car service representative takes the customer name and address and the class of vehicle and period of rental (date and time in and out) that the customer desires. The customer is informed of the rental rate.

When the customer arrives at the branch location to pick up the car, the service representative first checks for a reservation and, if a reservation exists, she draws up a rental agreement. At that time the service representative obtains other customer information, such as his operator's license number and state that issued it and the customer's credit card type and number, including the expiration month and year. If the customer has made a reservation, then the reservation information is used to assign a specific vehicle to the rental agreement. If the customer is a walk-in (no reservation), the service representative fills out the reservation information first as part of the process. All rentals must be associated with a reservation. The rental agreement has a contract number that uniquely identifies it, the VIN number of the vehicle that is being rented, the current date and time for the rental to start, and a current odometer reading. The customer is given copy of the rental agreement along with the keys to the car. This ends the activities at the time the vehicle is picked up.

After use, the car is returned to the branch location. Information that will be filled in when the car is returned is the date and time at which the rental ends and the ending odometer reading. When the rental agreement is completed, the actual cost of the rental is computed using the class rental rate and the cost is charged to the customer's credit card. No other form of payment is accepted