Normalization

Show all the steps as you perform normalization for each problem up to 3NF. State your final relation to schemas in 3NF.

2. Given the EMPLOYEES relation below: Emp no 25 23 38 17 57 Ename Clay Thaisz Good Baid Brown Lcode NJ5101 NJ5101 FL6321 NY2091 NY2092 Lstatus 1 1 4 3 3 Ename, Lcode, The relation schema for the above relation is EMPLOYEES (Emp no, 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