Develop an EER model for the following situation using traditional EER notation. You have been hired by a new start$-$up company, IT Consulting $$ a company that consults with corporations to determine their security needs. You have come up with the following set of entities, attributes, and business rules:

CONSULTANT

$2$ types of consultants $$ business consultants and technical consultants. Business consultants first works with a company for security needs and gives the estimates, technical consultants perform services according to specifications developed by business consultants.

Attributes of Business consultant: Employee$\_$ID $($primary key$),$ Last name, First name, Street City, State, Zip, home phone, date of birth, age, years in business, type of business, degrees received.

Attributes of Technical Consultant: Employee$\_$ID $($primary key$),$ Last name, First name, Street City, State, Zip, home phone, date of birth, age, technical skills, degrees received.

CUSTOMER

Customers are businesses that have asked for consulting services.

Attributes of Customer: Customer ID $($primary key$),$ Company Name, Company Street, Company City, Company State, Company Zip, Contact Name, Contact Title, Contact Telephone $($more than one$),$ Business type, number of employees.

LOCATION

Customers can have multiple locations.

Attributes of Location: Customer ID $($primary key$),$ Location ID $($part of primary key$),$ Location Street, Location City, Location State, Location zip, location telephone, building size $($square feet$).$

SERVICE

Service is performed for a customer at one or more locations. Before services are performed an estimate$($cost$)$ is prepared.

Attributes: Service ID $($primary key$),$ description, cost, coverage, clearance required

Hint! $($the following can become entities in your tables if needed & probably will!!$)$

Service Estimates $$ attributes are Date, Amount, Employee$\_$ID$,$ service ID $($primary key$),$ and customer ID$.$

Services performed $$ attributes are Date, amount, Employee$\_$ID$,$ service ID $($primary key$),$ and customer ID$.$

Assume the following:

A customer can have many consultants providing many services. You want to track actual services performed and services estimates $$ therefore, there needs to be a two$$way relationship between customer, service, and consultant.

REMEMBER THAT THESE SHOULD BE IN YOUR EERD $($Each holds $5$ marks$)$

$1.$ Entities connected neatly and clearly according to the specifications in the scenario.

$2.$ All the attributes mentioned, and its type denoted.

$3.$ Denote Primary key$/$composite keys and foreign keys.

$4.$ Relationship names

$5.$ Include Cardinality Constraints with one, many, mandatory and optional.

$6.$ Add Subtype Discriminator & its values.

$7.$ Mention all the vital details including your Name, Class & Section in your work.

$8.$ Use correct file type for submission $($a Dia, Visio or Drawio is acceptable$).$