Home /
Expert Answers /
Computer Science /
draw-an-entity-relationship-diagram-erd-using-unified-modeling-language-uml-notation-according-pa942
(Solved): Draw an Entity Relationship Diagram (ERD) using Unified Modeling Language (UML) notation according ...
Draw an Entity Relationship Diagram (ERD) using Unified Modeling Language (UML) notation according to the below business rules. Your design should be at the logical level-include primary and foreign key fields, and remember to remove any many-to-many relationships. Scenario: Emplovee Management Svstem You are tasked with designing a database for an Employee Management System for a corporate organisation. Create an Entity Relationship Diagram (ERD) in Unified Modeling Language (UML) notation based on the given business rules. Pay attention to the mark allocation outlined below. Businessinules: 1. Each employee is assigned to one department, and each department has multiple employees. 2. The first name, last name, and employee ID of each employee must be stored in the database. 3. Employees can have multiple skills, and each skill can be possessed by multiple employees. The name and description of each skill should be stored in the database. 4. Each department has one manager, and each manager oversees exactly one department. 5. Employees participate in various projects, and each project involves multiple employees. 6. Each project has a project leader, and each project leader oversees exactly one project.\r\n\r\nMark allocation: Entities: 5 marks Relationships: 4 marks Multiplicities: 4 marks Primary keys: 5 marks Foreign keys: 4 marks Other attributes: 2 marks Correct UML notation: 1 mark