In this project, you will design and implement a database for keeping track of information about a car rental company. You will first design an ER/EER schema diagram for this database application. Then, you will map the ER/EER schema diagram into a relational database schema and implement it on MySQL relational DBMS preferable. Finally, you will load data into your relational database, write some queries, as well as a program to enter the query parameters and display the results.
Assume that the following requirements collected for this application:

1. The database keeps track of CUSTOMERs. Each CUSTOMER has a unique CustId (assume this is a unique integer generated by the system for each new CUSTOMER, such as 1, 2, 3, …), a Name (assume this is string consisting of a single initial and last name only for simplicity, such as "J. Smith" or "R. Wong"), and a Phone (a string of 12 characters such as "817-272-3000").

2. The database keeps track of CARs available for rental, which are categorized based on their type. The fleet is categorized as ‘LUXURY’ or ‘BASIC’ and belongs to any of the following six types: COMPACT, MEDIUM, LARGE, SUV (Sports Utility Vehicle), TRUCK and VAN. Each type of car has its own DailyRate and WeeklyRate (assume all vehicles of the same category and type have the same rental rates). For simplicity, we will assume that there is only one rental location.

3. Each CAR has a VehicleID (a unique number for each car), a Description (consisting of the brand name and model, such as Honda Civic, Toyota RAV4, Mazda CX5, …), and Year (2014, 2015, …).

4. The database will keep track of the past, current, and scheduled RENTALS of each CAR. There are two types of RENTAL: DAILY and WEEKLY. For each DAILY RENTAL, the information kept will include the specific CAR and CUSTOMER as well as the NoOfDays, StartDate, and ReturnDate (the ReturnDate derives from the StartDate and NoOfDays). For each WEEKLY RENTAL, the information kept will include the specific CAR and CUSTOMER as well as the NoOfWeeks, StartDate, and ReturnDate (the ReturnDate derives from the StartDate and NoOfWeeks). Each rental will also have the AmountDue for the rental, which is a derived value that can be calculated from the other information. We also need to keep information for the OrderDate.

5. The CUSTOMER has the option to pay in full either at the OrderDate or at the ReturnDate. For each PAYMENT we want to keep track of the PaymentDate, PaymentAmount, and a reference to the corresponding RENTAL. 6. The application needs to be able to identify which CARs are available for rental during a given period.