Conceptual Data Modeling

Create a data model (ERD) based on the following business rules. You must:

Identify all of the main entities.

Identify all of the relations and connectivities.

Identify PK and FK

Identify the type of participation optionality, existence dependency and relationship strength in all the relationships.

Resolve the many to many relationships using the associative entities.

Identify subordinate relationships (super type vs. sub type).

You must use Lucidchart to draw the ERD (and then copy and paste your complete diagram).

In HAVAC company, the following employee information is stored: Employee ID, First and Last name, Rank, and billing rate. Employees are organized into specialties, each specialty has a manager of that specialty, who is coordinating the assignment of all employees in that specialty to the projects. For each specialty, we record the specialty ID and name. An employee can belong to only one specialty.

The scheduling system also stores information about project. For each project, the following information is stored: Project ID, Status, Location. More than one employee can be assigned into the project. When an assignment is requested for an employee, the employee is scheduled to work on a particular project, for the specified amount of his full available time (10%-100%). So, one employee can be assigned in multiple projects.

Hint: You may consider two relationships between SPECIALITY and EMPLOYEE. One for managing the specialty and the other for general belonging to the specialty.