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

As pollution is increasing, some large cities

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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!