You are designing and creating a database named COMPANY for an HR

$($Human Resource$)$ Dept of a Software Consulting Company to manage their

employees and their assigned work $($projects$)$ in the company.

First Step to Design and Create a Database is Creating an E$-$R Diagram by

Identifying Entities, Attributes and Relationships between any two

Entities to Create a Company Database Scheme.

Create an E$-$R Diagram for the Company database from the raw data

files given below and the business rules of the company given below

using the symbols of E$-$R Diagram.

To create the E$-$R Diagram for the Company database, we identified $4$

Entities in class as below.

For each Entity given below:

Identify all the attributes for each Entity

Identify the Attribute Types: Key attributes, Multi$-$Valued Attributes,

Composite Attributes, and Derived Attributes.

For any two entities and the given Compamy rules below:

Identify all relationships between $4$ Entities below to create E$-$R

Model for the Company database scheme.

Entities:

Employee

Department

Dependent

Project

Company Rules:

Every employee should work for one department.

Every employees should work on the projects.

A Manager is the one who manages a Department.

Every Department can have only one manager.

A Supervisor is the one who supervises his$/$her employees.

A department controlls projects.

A project can be controlled by only one department.

Some departments are located in multiple office locations

For each realtionship you identified,

Name the realtionship

Identify the cardinality of the relationship between two entities as

either

$1-1$

$1-NorN-1$

$N-M$

Identify participant types: Total or Partial Participation for each entity