Consider the following scenario and then answer the corresponding questions.

SpeedWay, an online car rental company, is ready to launch its online application to enable users to make car rental reservation. Users can search for a car by first entering the location from where they will be renting the car. Users will be prompted to select the pickup location from the search results. Users will then select a pickup date/ time and a return date/time. Users will then enter their age and proceed with the reservation. Then the users will then be prompted to select the vehicle class which could be one of the following Compact, Economy, Intermediate, Standard, Full Size, SUV, Mini van, Pick-up Truck, 15 passenger van and Cargo Van. During this step, users can also click on a particular vehicle class to view additional details like vehicle type, passenger capacity, diesel or gas fuel, AM/FM Stereo CD/ MP3, Air Conditioning, power door and Cruise Control. Once users select a vehicle class they are interested in renting, they will be shown an order page where the price for the rental and the estimated taxes and fees are shown. Users will be prompted to enter the contact details, (first name, last name, phone number, email, address) at this stage. Optionally users can also provide information about the drivers license (Issuing country, Issuing Authority, DL number) and complete the reservation, so they can save time when they go to the location to pick up the vehicle. Once the reservation is complete, users are shown an order summary page with a reservation number and all relevant details as provided by the users in the previous steps. The user can additionally/ optionally view information on rental terms and conditions, Insurance coverage options personal accidental Insurance, Personal effects coverage, Loss Damage waiver, Renter Requirements, Road Side assistance, and toll policy. The system will also allow the individual renting location to keep an inventory of all cars available. Employees assisting users with renting a car should be able to keep this inventory list updated every time a car is rented out or returned back to a location.

Upon your review complete the following:

1. Identify all the tables relevant this case, the primary key, foreign keys, attributes and data types. (30 pts). (Hint: Refer to your class diagram). Minimum 6 tables.

2. Apply 1^st, 2^nd and 3^rd normalization rules for your tables. Explain how each table satisfies these normalization rules. (Hint: You may end up creating intersection tables as needed, in addition to the tables identified above). (20 points)

3. Draw an ER diagram for this case including the tables, relationships, cardinality and all the fields. (10 points)