Normalization

by | Nov 1, 2020 | Main

The table below represents employees working on various contracts.
empID |contractNo | hours|lastName |firstName | state |branchNo
1135 | C1024 | 16 | Smith | John |Illinois| 1
1057 | C1024 | 16 | Smith | Harry |Illinois| 1
1058 | C0006 | 20 | Simpson | Maggie |Illinois| 2
1068 | C1025 | 20 | Adler | Rachel |Maryland| 3
1135 | C1025 | 20 | Smith| John |Maryland| 3
1068 | C5321 | 40 | Adler | Rachel |Maryland| 3
1234 | C6651 | 15 | Potter| Harry |New York| 4
1234 | C5321 | 40 | Potter| Harry |Maryland| 3

  1. What is the primary key? _________________________________________________________
  2. Please list all functional dependencies that violate 2NF? _________________________________________________________ _________________________________________________________ _________________________________________________________ _________________________________________________________
  3. Please list all functional dependencies that violate 3NF?
  1. Fix any 2NF violations and draw the new tables you have and their attributes. Fill in the rows. Remember to remove redundant rows. Specify the primary key by underlining the appropriate attribute(s) for each table.
  2. Using the latest updated tables, fix any 3NF violations and draw the new tables you have and their attributes. Fill in the rows. Remember to remove redundant rows. Specify the primary key by underlining the appropriate attribute(s) for each table.

Sample Solution

This question has been answered.

Get Answer