(Solved): Using SQL 2.2 USF Rent-a-Car keeps track of its vehicle fleet using a database with the following ta ...

2.2 USF Rent-a-Car keeps track of its vehicle fleet using a database with the following tables: LOCATION - These are the locations that maintain and rent the cars. CLASS - This is a grading system for rental rates. MODEL - This is a description of the model types that USF Rent-a-Car has in its fleet. CAR - These are the actual vehicles that are owned and rented by USF Rent-a-Car. All attributes are text data types except YEAR, which is numeric and the rental rates, which are currency data types. (a) For each table, identify the primary key(s) and foreign key(s). (b) Create the database and populate the tables. (c) Write the SQL commands for the following: (1) List the vehicle identification number (VIN) of all Chevrolets. (2) List the VIN and year of all Chevrolet Impalas located at St. Petersburg. (3) List all Volkswagon Passat cars by location and VIN as follows: (4) List all red standard cars by location_ID and VIN. (5) How many full-size cars are owned by USF Rent-a-Car? (6) How many compact cars are located at the Tampa location? (7) What is the cost savings by class for a customer who pays the weekly rate for a 7-day rental instead of the daily rate? (8) List the different classes that are located at each location as follows: