Question: As pollution is increasing, some large cities have started a project called car-sharing to reduce the number of cars in the city and also reduce


As pollution is increasing, some 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, 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 assumptions. As pollution is increasing, some 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, 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 assumptions
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
