As pollution is increasing, som large cities have started a project called car sharing to reduce the number of cars in the city and also reduce the cost of having a car available when needed by a person. A car is partially owned by several people. A car has an identification, car make, car model cartag, and car insurance. The owner has an identification, and their last name and first name are recorded. Typically, owners can own one or more car but with different percentage for each car depending on how often they use the car. Since cely one person can use the car at any particular time, the owner needs to keep track of reservations made for the car. The owner can reserve one or more cars for different days and time slots and the car can be reserved by multiple owners in the same day but not at the same time. Your data model should keep track of the owners of each car and the reservation of the car. Make the necessary assumption 1. Draw an ER diagram for the car owner reservation system. (20 points) Save as MS320-L Your Name Model Project.www and ensure you upload the file into both the BMIS 20 and BMIS320L courses 2. Write Solto create the tables for the ER diagram and be wore to specify primary and foreign keys (20 points) Save as BMIS 20-L Your Name Tables Project sql and ensure you upload the file into both the BMIS320 and BMIS320L courses 3. Complete the following queries for the car owner reservation system you created a List the names of the owners in alphabetical order, when two owners have the same last name, order by first name (4 points) b. List the count of available cars per car model (4 points) c. List details of cars that are not made by traditional German firms tiecar model is BMW, Audi, Mercedes vw points) d. List details of the cars with model that has a double for points) e List the number of reservations made by cach person. (6 points) List the cart of the car owned by more than one person. 16 points) Calculate the total car insurance paid by each person assuming the amount someone pays for insurance of a particular car is equivalent to the percentage owned of that car multiplied by the insurance fee 7 points) h. List all the car information owned by Jad Youssef. (7 points) i List the names of people who have a 100 percent share of a car with Audi(make) and TT (model) pints) Create a view TotalInsurance View for the query in questi (points) Save all queries into one file as BMIS120-L Your Name Oueries Projecteld ensure you upload the file in both the RMS 120 MIS120L courses Note: Students are to complete the project individually or in a grow with no more than the students As pollution is increasing, som large cities have started a project called car sharing to reduce the number of cars in the city and also reduce the cost of having a car available when needed by a person. A car is partially owned by several people. A car has an identification, car make, car model cartag, and car insurance. The owner has an identification, and their last name and first name are recorded. Typically, owners can own one or more car but with different percentage for each car depending on how often they use the car. Since cely one person can use the car at any particular time, the owner needs to keep track of reservations made for the car. The owner can reserve one or more cars for different days and time slots and the car can be reserved by multiple owners in the same day but not at the same time. Your data model should keep track of the owners of each car and the reservation of the car. Make the necessary assumption 1. Draw an ER diagram for the car owner reservation system. (20 points) Save as MS320-L Your Name Model Project.www and ensure you upload the file into both the BMIS 20 and BMIS320L courses 2. Write Solto create the tables for the ER diagram and be wore to specify primary and foreign keys (20 points) Save as BMIS 20-L Your Name Tables Project sql and ensure you upload the file into both the BMIS320 and BMIS320L courses 3. Complete the following queries for the car owner reservation system you created a List the names of the owners in alphabetical order, when two owners have the same last name, order by first name (4 points) b. List the count of available cars per car model (4 points) c. List details of cars that are not made by traditional German firms tiecar model is BMW, Audi, Mercedes vw points) d. List details of the cars with model that has a double for points) e List the number of reservations made by cach person. (6 points) List the cart of the car owned by more than one person. 16 points) Calculate the total car insurance paid by each person assuming the amount someone pays for insurance of a particular car is equivalent to the percentage owned of that car multiplied by the insurance fee 7 points) h. List all the car information owned by Jad Youssef. (7 points) i List the names of people who have a 100 percent share of a car with Audi(make) and TT (model) pints) Create a view TotalInsurance View for the query in questi (points) Save all queries into one file as BMIS120-L Your Name Oueries Projecteld ensure you upload the file in both the RMS 120 MIS120L courses Note: Students are to complete the project individually or in a grow with no more than the students