$1)$Some large cities $($e$.$g$.,$ Cologne, Germany$)$ have started a project called car$-$sharing to reduce the number of cars in the city and also to reduce the cost of having a car available when needed by a person. One car is partially owned by several people. The number of owners per car may vary. Typically, not more than four people own one particular car. Also, each person can own a different percentage of the car, depending on how often she uses the car. Each person might own a share of more than one car. Obviously, only one person can use the car at any particular time. Thus, a database is needed to keep track of reservations made for the car.

Write SQL to create the database for the following data model. Be sure to specify primary and foreign keys.

$2)$ Write the following queries based on the database created in problem number $1.$

a$)$ List the car tag of those cars owned by more than one person.

b$)$ List details of cars that are not made by traditional German firms $($BMW$,$ Audi, Mercedes, VW$)$

c$)$ List the number of reservations made by each person.