Is this relation in 1NF? If not create the 1NF. If yes explain why.

Write down the functional dependencies

Use the functional dependencies to explain what the candidate key is.

Transform to 2NF

Transform to 3NF

Store_Name Store_Mgr Emp ld Hours_per_week Revenue Opening_Date Emp Salary Emp super Emp Dept Rating PA Store Jones E-101 25 100000 1/15/2015 60000 Levine 10 PA Store Jones E-105 40 100000 1/15/2015 55000 ones 12 8 PA Store Jones E-110 10 100000 1/15/2015 43000 Levine 10 8 NJ Store Smitlh E-101 15 200000 3/1/2014 60000 Levine 10 NJ Store Smitlh E-110 30 200000 3/1/2014 43000 Levine 10 NJ Store Smitlh E-120 40 200000 3/1/2014 45000 ones 15