StoreSore_Name	Store_Mgr	Emp_Id	Hours_per_week	Revenue	Opening_Date	Emp_Salary	Emp_super	Emp_Dept	Rating
Pink_store	Bob	E-11	25	300000	1/15/2015	60000	Alice	10	9
Pink_store	Bob	E-5	40	300000	1/15/2015	55000	Bob	12	8
Pink _Store	Bob	E-6	10	300000	1/15/2015	43000	Alice	10	8
Blue_store	Alice	E-11	15	500000	3/1/2014	60000	Alice	10	7
Blue _store	Alice	E-6	30	500000	3/1/2014	43000	Alice	10	9
Blue _store	Alice	E-2	40	500000	3/1/2014	45000	Bob	15	9

You can make the following assumptions:

1. Each store has one manager
2. Each employee has one supervisor
3. Many employees are assigned to each store. The attribute Hours tells the number of hours each employee has worked on the corresponding store per week and the attribute rating is the rating that this employee received for his work on this store.
4. Revenue and opening date refer to the store

Based on this information:

1. Is this relation in 1NF? If not create the 1NF. If yes explain why.
2. Write down the functional dependencies
3. Use the functional dependencies to explain what the candidate key is.
4. Transform to 2NF
5. Transform to 3NF