The purpose of this assignment is to normalize a set of data with additional information.

Scenario:

Lab 3.1 contained employees, projects and departments. We have now received more information. Each project is broken down into tasks. Every task is assigned a unique number and name. However, for this assignment, we will assume that only the task number is unique. The same task can be included in different projects. The t_duration is the estimated time that a task should take for any particular project. Finally, t_tool is the software needed to complete the task.

You have the following attributes (e = employee, p = project, d = department, t = task): eno, ename, pno, phours, pname, ploc, ebdate, eadd, dno, dname, dmngno, tno, tname, t_duration, t_tool

Instructions:

1. Identify the dependencies for example: dno determines the dname, dmngno. There are five other dependencies.
2. Draw a dependency diagram showing all dependencies; note on the diagram any partial dependencies and transitive dependencies and the primary key(s) of the universal set.
3. Decompose the universal set into 1^st through 3^rd normal form tables. Remember that each set must contain all attributes and each successive form contains more sets. Each set at each successive form must have a primary key identified.
4. Your final 3^rd normal form set should contain six tables. Name the tables and identify each table as an Entity or a Relationship.