2.3 Exercise: Determine the normal form

Classify the following relation as either UNNORMALISED, 1NF, 2NF or 3NF.

EMPLOYEE(empno,empname,jobcode,jobdesc)

  1. Unnormalised.
     
  2. 1NF.
     
  3. 2NF.
     
  4. 3NF.
     

Index