2. Given the EMPLOYEES relation below: Emp_no 25 23 38 17 57 Ename Clay Thaisz Good...

Transcribed Image Text:

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 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. 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 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.

Answer rating: 100% (QA)

Answer There are two candidate keys Empno Lcode Functional Dependency Empno Lcode Ena... View the full answer