Auto Repair Shop

An auto repair shop, that sells and mounts parts and accessories for all kinds of vehicles, wants a new information system to manage their clients, parts, accessories and assembly services:

There are several employees. Each employee has a unique identifying number, a name and an address.
The auto shop provides assembly services, where parts and accessories are installed in a vehicle. For each one these assembly services, the following information must be stored: the car in which the service was executed, how many kms the car had at the time, who was the employee responsible for the service, which parts and accessories were installed, how many work hours did it take and the admission and finish dates.
Parts and accessories are only sold together with an assembly service.
Each part/accessory only fits in some car models. Therefore, it is important to store that information.
Each part/accessory has a type (radio, tyre, …), a serial number and a price.
Each car has a license plate, a make, a model, a color and an owner. Each owner has a name, identifying number, address and a phone.
One person can own more than one car but one car only has one owner.

Acknowledgement

Credits: André Restivo