Using a drawing tool, draw an E-R diagram for the Employee-Project-Department example described below.

Note: This assignment should include three E-R diagrams (one for each step).

Note: Drawing tool software such as Microsoft Visio or similar products should be used for this laboratory exercise. If these are not available, the drawing tool in Microsoft Word or the Windows Paint program may be used.

Step 3.1 - Consider the entity set Employee with attributes: empId, socSecNo, empName, jobTitle, and salary.

Step 3.1.a - Identify all candidate keys for the Employee entity set.

Step 3.1.b - Show how the Employee entity set and its attributes would be represented on an

E-R diagram.

Step 3.1.c - Identify the primary key for the Employee entity set and underline it on the E-R diagram.

Step 3.2 - Assume in the same enterprise, that there is a second entity set called Project with attributes: projNo, projName, startDate, endDate, and budget.

Step 3.2.a - Show how the Project entity set and its attributes and its relationship to Employee would be represented on the E-R diagram.

Step 3.2.b - Identify the primary key for the Project entity set and underline it on the E-R diagram.

Step 3.2.c - Assume you want to represent the number of hours an employee is assigned to work on a project. Show how this would be represented on the E-R diagram.

Step 3.2.d – State the necessary assumptions. Make a decision about the cardinality and participation constraints of the relationship between Employee and Project, and add the appropriate symbols to the E-R diagram.

Step 3.3 - Assume in the same enterprise, that there is a third entity set called Department with attributes: deptNo, deptName and mrgName.

Step 3.3.a - Show how the Department entity set and its attributes and its relationship to Employee would be represented on the E-R diagram.

Step 3.3b - Identify the primary key for the Department entity set and underline it on the E-R diagram.

Step 3.3.c - Assume that each employee works for only one department. Projects are not directly sponsored by a department. Show how this would be represented on E-R diagram.

Step 3.2.d – State the necessary assumptions. Make a decision about the cardinality and participation constraints of the relationship between Employee and Department, and add the appropriate symbols to the E-R diagram.

Answer rating: 100% (QA)

Unfortunately Im unable to draw images within this textbased medium However I will still explain how each step would be presented in a diagram for the ... View the full answer