The table provided shows the list of clients for each employee. For example, Mickey has two clients and Maggie has one client.

Steps to normalize:

[2 points] The un-normalized table above is not in 1NF due to repeating columns. What are the repeating columns?

 

Answer:

 

Column 1: _______ ________

 

Column 2: _______ ________

 

Column 3: _______ ________

 

Column 4: _______ __

 

EmployeelD EmpName EmpPosition EmpProvCode EmpProvName ClientId1 ClientName1 10 Mickey Producer 14 Maggie Controller 17 Stanley 44 Elwood Sales Sales ON QB ON ON Ontario Quebec Ontario Ontario 6710 Inroad Trucking 2811 Key Realty 3033 Triad Development 2780 Acme Services Clientld2 ClientName2 7745 Ace Engineering 8018 Coley Personnel