Urgent help please! Please draw complete ERD in paper. Thankyou.

Create an ERD for a car service facility.

Base your design on the following business rules:

Each car is identified by VIN number. We store the model and the make of the car.

For each mechanic, we keep track of name, address, and the hourly wage; and they are identified by their SSN$.$ A head mechanic is an experienced mechanic.

A head mechanic investigates the car at each visit and identifies required and recommended services.

Each required and recommended service is stored, with the service id from the service manual $($You do not need to model service manual$)$

The ticket contains the date of the visit. Tickets are identified by id $($surrogate key$),$ the ticket is issued to a car by a mechanic.

The service can be worked by many mechanics, and each mechanic may work on many services. We need to record the time spent by each mechanic on each car service. Specifically, we record when a mechanic starts working on a car and when he $($she$)$ finishes working.

The service may or may not need parts $($e$.$g$.,$ adjusting a carburetor or cleaning a fuel injector nozzle does not require providing new parts$).$

Parts can be bought by the customers and handed to the service facility, or the service facility can obtain these parts purchased We record the date of purchase and when the warranty would expire. Parts are identified by their sku.

We maintain a service history for each car, those are the services that have been actually performed. We need to add the date of these services.

We compute the percentage that each mechanics worked on each car. Note that a mechanic can work on more than one car in the same time.

Draw an ER diagram that captures the preceding information. Identify any constraints not captured by the ER diagram.