Question

1. Create a dependency diagram for the set of given columns for the EMP table:

EMPID	Employee’s ID
LAST	Employee’s last name
FIRST	Employee’s first name
DEPTID	Employee’s department number
DEPTNAME	Employee’s department name
DEPENDENTNO	Employee’s number of dependents
DEPENDENTSSN	Dependent’s Social Security Number
DEPENDENTDOB	Dependent’s date of Birth
PROJNO	Employee’s project number
PROJNAME	Project name
PROJTYPE	Project Type
PROJDESC	Project Description

2. Using the dependency diagram of the EMP table from #1 above, normalize the table to 3NF. Use 1NF-to-2NF and then 2NF-to-3NF conversion from Chapter 2 in DSUO.

Answer 1