Consider the following relations, and identify the highest normal form for each, as given, stating any assumptions you need to make.

a. Work1 (empId, empName, dateHi red, jobTitle, jobLevel)

b. Work2 (empId, empName, jobTitle, rating Date raterName rating)

c. Work3 (empId, empName, projectNo, projectName, proj Budget, empManager, hoursAssigned)

d. Work4 (empId, empName, school Attended, degreeAwarded, graduation Date)

e. Work5 (empld, empName, social SecurityNumber, dependent Name dependent Address relationToEmp)

For each of the relations in above, identify a primary key and:

a. if the relation is not in third normal Form, find a 3NF lossless join decomposition that preserves dependencies.

b. if the relation or resulting set of relations is not in Boyce-Codd Normal form, find a lossless join decomposition that is in BCNF. Identify any functional dependencies that are not preserved