Aim: To give you practical experience in with database modelling, normalization and writing SQL statements.Background InformationABC Car Rentals will be starting operations in 2017. They require a database system to cater for the rentals of their vehicles.When a person rings up or comes into the office of ABC to book a vehicle for the first time they are asked to provide their name, address, and telephone number. The vehicle date out, time out, odometer reading, and fuel out is entered into the system when a vehicle is rented by a customer. When the vehicle is returned then the date in, time in, odometer reading, and fuel in is entered. The number of days is calculated and the customer is billed for the car rental plus additional charges such as cleaning, petrol, a fuel refilling fee, damage to hire car, toll fees, smoking fee, and administration charge. Once the rental is complete and details about the rental have been entered then the customer is invoiced for the hire of the vehicle. Payments are recorded for each rental record. Payments are expected to be in full. However, the system allows multiple payments to be recorded against each rental record.The database system also needs to keep a record of vehicle servicing which includes the last service date, a service description, and the next service due date.AssumptionsSome charges have a fixed cost. However, the charge amount may be adjusted up or down when charges are entered against a rental record. Total charges are calculated by the system by multiplying the charge amount (price) by the quantity.System RequirementsThe system is a prototype