What normal form is the relation in? Normalize it up to 3NF.

IT/BIFX 530 Applied Database Systems

1 of 1

Homework 4: Normalization

Consider the following relation that involves student data:

Assume that only one professor teaches a class section, and professors teach in only one department. Suppose the following dependencies exist:

What normal form is the relation in? Normalize it up to 3NF.

Given the EMPLOYEES relation below:

Emp_no Ename Lcode Lstatus

25 Clay NJ5101 1

23 Thaisz NJ5101 1

38 Good FL6321 4

17 Baid NY2091 3

57 Brown NY2092 3

The relation schema for the above relation is EMPLOYEES(Emp_no, Ename, Lcode,

Lstatus), where

Emp_no: employee number

Ename: employee name

Lcode: location code

Lstatus: location status, each location has a status code

What normal form is the relation in? What are the dependencies? Normalize it up to

3NF.

Submission Instructions

1) Type up your solutions for both problems making sure that you answer all questions for each problem. Also, make sure that you show all the steps as you perform normalization for each problem up to 3NF. Clearly state your final relation schemas in 3NF. Submit the homework through the assignment link on Blackboard