Create a Erd diagram using lucid chart for following description.Acme Autos has hired you to create a database to manage car sales and service visits at its five

branches. Before building the database you conduct a preliminary analysis to identify the

entities, relationships, and business rules relevant to Acme. Use the following analysis to create

an ERD:

Each of Acme$$s branches has a branch ID$,$ address, and phone number. Each branch has its own

unique group of employees. Every employee has an employee ID$,$ name, and date hired.

While there are many employee types working at each branch, two types of employees

$($salesperson and mechanic$)$ have additional information stored about them. For a salesperson,

Acme records their annual sales goal. Acme is also interested in each salesperson$$s sales to

date $($a value that may change multiple times in a day$).$ For a mechanic, Acme records their

technical certifications $($a mechanic may hold multiple certifications$).$ At one of Acme$$s

branches there is a salesperson who also works part$-$time as a mechanic.

Each of Acme$$s branches offers multiple vehicles for sale $($each vehicle belongs to one, and only

one, branch$).$ Each vehicle has a vehicle ID$,$ make, model, year, color, and features $($vehicles

have multiple features$).$ ACME classifies its vehicles into three categories: economy, luxury,

and utility. For an economy vehicle, ACME records the miles per gallon. For a luxury vehicle,

ACME records the interior finish. For a utility vehicle, ACME records if the vehicle is four$-$wheel

drive $($Y$/$N$).$ Each vehicle belongs to a single classification.

Each of Acme$$s customers has a customer ID$,$ name, address, phone number, insurance

company, and policy number.