This is a car renting business and database collects

1. The snapshot of Car_HireDB database structure of “Rent a car” company is given in Figure 1.This is a car renting business and database collects information about customers, cars and details of booking made online.For each booking system assigns unique booking ID, and stores date of hire and date on which the vehicle is to be returned and payment received (amount). Customers make their payments at the time of booking. A customer cannot hire a car for longer than a week.You are working as an IT specialist in this organisation and are required to extract information from this database by executing SQL queries according to the instructions given below.The primary keys are marked in the Car_HireDB database, shown in figure1.