Problem:
Use following business rules to make the E-R diagram. You must clearly show all the minimum and maximum cardinality constraint on each side of relationship.
King Car Enterprise runs the high quality car sales operation for which they give a complete customer after sales service. In order to offer this service they keep records of service needs of each type of car that they sell. This information comprises how often a service is required in terms of number of months between services and distance covered. A car is serviced either when a predefined period has elapsed or vehicle has covered a particular distance, whichever is the sooner.
A record is kept of names and addresses of car owners. For each car which a customer owns a record is kept of registration number of car, the type of car, the date it was sold to customer, the recorded distance traveled by vehicle and the average distance undertaken by owner per month.
When a customer makes a booking for a service a record is kept of registration number of the vehicle and the date for which the service has been booked. At last, a record is kept of the service history of a car which comprises the dates, on which the vehicle was serviced, the registration number of the vehicle and the vehicle mileage when the service was performed.
The primary goal of computer system is to be capable to send reminders to customers that a vehicle they own is due for service.