staffNo	branchNo	branchAddress	name	position	hoursPerWeek
S4555	B0002	City Center Plaza, Seattle, WA 98122	Ellen Layma	Assistant	16
S4555	B0004	16 14th Avenue, Seattle, WA 98128	Ellen Layma	Assistant	9
S4612	B0002	City Center Plaza, Seattle, WA 98122	Dave Sinclair	Assistant	14
S4612	B0004	16 14th Avenue, Seattle, WA 98128	Dave Sinclair	Assistant	10

(a) Why is this table not in 1NF?

(b) Describe and illustrate the process of normalizing the data shown in this table to third normal form (3NF).

(b1) find all functional dependencies (b2) find minimum cover (b3) find super key

(c) Identify the primary and foreign keys in your 3NF relations

Note. hoursPerWeek represents the number of hour each staff member works at a give branch.

Submit a word document highlighting all the steps that are asked in this exercise (reference to LAB for guidance). Make sure all final tables generated and shown in the submission document.