Question

Draw the Crow’s Foot database notation entity-relationship diagrams (ERD) to represent the databases, based on the three narratives below. Use Lucid Chart or another ERD diagramming tool to create your diagram. You do not need to create the databases, but to design it using applicable business rules according to your judgment. Submit a PDF of the Entity Relationship Diagram for each database.

Remember to identify in your diagrams:

• All the main entities and the main attributes for each entity
• The relationship between the entities, whether they are “optional” for example.
• The attributes which are primary keys and foreign keys, noted as “+”, and “#” respectively in the diagrams.
• Use any feature of the software you can (think “sticky notes” or comments) to explain the relationships/cardinality between entities.

1.

You are the Director of Human Capital at Oliver Wyman. You need to keep track of the many divisions, departments and positions within the departments. Employees have a position within the department and division, and you need to keep track of how long each employee has worked at the company, who the supervisor of each department is, what projects employees are working on, and the percentage of the time they allocate to each projects.

Some of the business rules include (this is not complete list of business rules; you may need to identify or define more business rules):A division has many departments, and each department is operated by one division.

• A division has many departments, and each department is operated by one division.
• A department has one or many positions. each positions is operated by one department
• One position can have zero, one or many employees, and employees can have one or more positions.
• An employee can be assigned to multiple projects, and a project may involved many employees. A project must have at least one employee assigned to it.

Answer 1

ERD database(Crow's Foot)

----------------------------------------------------------------------------------------------------------------------------------------------------------

Kindly comment your queries if any,upvote if you like,Thank you.