Module 4 Lab 43 of tis an 14 HA Assignments Module 4 Lab 4.3: Normalize assignment Module 4 Lab 4.3: Normalize assignment Due Sunday by 11:59pm Points 30 Submitting a file upload File Types dosc nts 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 rwumber and name. However, for this as number is unique. The same task can be inckuded in ditferent projects. The for any particular project. Finally, t. tool ie the software needed to complete the task assignment, we will assume that only the task t duration is the estimated time that a task should take ploc You have the following attibutes (e - empioyee, p- project, d - department, t - task; eno, ename, pno, phours, pname ebdate, eadd, dno, dname, dmngno, tno, tname, t duration, t tool Instructions: 1. ldentify the dependencies for example: dno 2. Draw a dependency diagram showing all dependencies note on the diagram any partial dependencies and transitive determines the dname, dmngno. There are five other dependencies dependencies and the primary key(s) of the universal set. Decompose the universal set into 1" through 3d normal form tables. Remember that each set must contain a attributes and each successive form contains more sets. Each set at each successive form must have a primary key identified 4 Your final 31 normal form set should contain sik tables Name the tables and identify each table as an Entity or a Relationship. 5. Submit ONE word document File Upload Google Doc Atomic Learning LTDropbo