As pollution is increasing, some large cities have started a project called sharing to reduce the number
Question:
As pollution is increasing, some large cities have started a project called 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 car tag 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 only 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 MIS320-L Your Name Medel Project.ww and ensure you upload the file into both the BMIS 20 and BMIS 20L courses 2. Write SOL. to create the tables for the ER diagram and be sure to specify primary and foreign keys. (20 points) Save as BMIS 20-L Your Name Tables Projects and ensure you upload the file into both the BMIS320 and BMIS3201 courses 3. Complete the following queries for the car owner reservation system you created List the names of the owners in alphabetical order, when two owners have the same last name, onder by first name ( points) b List the count of available as p ar model (4 points) e. List details of cars that are not made by traditional German firms i.e. car model is BMW, Audi, Mercedes VW), (5 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 (6 points) 2. Calculate the value 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), points) j. Create a view Totallence View for the query in questi (points) Save all queries into one files BMIS 20-L Your Name Oueries Projects and ensure you upload the file into both the BMIS 20 and BMIS 20L courses Note: Students are to complete the project individually or in a group with no more than the students
Applied Statistics for Public and Nonprofit Administration
ISBN: 978-1285737232
9th edition
Authors: Kenneth J. Meier, Jeffrey L. Brudney, John Bohte