Develop an Extended Entity Relationship Diagram $($EERD$)$ for the following scenario.

Show all components of an EERD such as entities, sub entities, attributes $($including composite

attributes$),$ primary keys, relationships, cardinalities, constraints, and specialization.

Scenario:

You have been hired by a company, IT Consulting Inc., whose consultants provide services to customers

at locations.

Assume the following:

Services may only be estimates or projects.

There is no overlap between estimates and projects.

Consultants may only be business consultants or technical consultants.

There is no overlap between business consultants and technical consultants.

Customers can have many locations.

Business consultants first work with the customer to develop the estimate.

Technical consultants then work with the customer to deliver the project.

Customers can have many businesses consultants providing many estimates.

Customers can have many technical consultants delivering many projects.

Remember to use composite attributes for address and phone number.

DATABASE:

ENTITY: SERVICE

Attributes of Service: Service$\_$Id$.$

$($add two additional attributes$).$

There are two categories of Service $($hint: sub entities$)-$ Estimate and Project

Attributes of Estimate: Estimate$\_,$

$($add two additional attributes$).$

Attributes of Project: Project$\_$Id$,.$

$($add two additional attributes$).$

ENTITY: CONSULTANT

Attributes of Consultant: Consultant$\_$Id$,$ First$\_$Name, Last$\_$Name, Street, City, Zip, DOB...$($add additional

attributes$).$

Two categories of Consultant $($hint: sub entities$)-$ Business Consultant and Technical Consultant

Attributes of Business Consultant: Business$\_$Skills...

Attributes of Technical Consultant: Technical$\_$Skills.

$($add two additional attributes$).$

ENTITY: CUSTOMER

Attributes: Customer$\_$Id$,$ Name, Company Street, Company City, Company State, Company Zip, Contact

Name, Business Phone $1,$ Business Phone, number of employees.

ENTITY: LOCATION

Attributes: Location$\_$Id$,$ Customer$\_$Id$,$ Street, City, State, Zip, Telephone, Building$\_$Size $($square feet$).$