Question 3: ( DATABASE APPLICATION DEVELOPMENT ) The following table represents the hours worked per week for temporary staff at eachbranch of a company. TempStaffHours staffNo Branch No Branch Office...

Extracted text: Question 3: ( DATABASE APPLICATION DEVELOPMENT ) The following table represents the hours worked per week for temporary staff at eachbranch of a company. TempStaffHours staffNo Branch No Branch Office Name Position Hours Address Phone Per Week Center 111125 Seattle, S4555 City Plaza, ВО02 Ellen Assistant 16 Layman WA 98122 S4555 ВО04 16 14th 422263 Ellen Assistant 9. Avenue, Seattle, Layman WA 98128 S4612 Center 111125 City Plaza,Seattle, ВО02 Dave Assistant 14 Sinclair WA 98122 S4612 B004 16 14th 422263 Dave Assistant 10 Avenue, Seattle, WA 98128 Sinclair S4718 Down Town 523632 Mary Kay ВО01 Cleaner 8 Alley, Jersey, JS 76542 a) Determine one anomaly that exist in the TempStaffHours table and criticize thedesign by giving an example of the anomaly. b) Given the following functional dependencies, perform normalization until the third normal form. Give justification related to anomalies on the design of the derived relations. staffNo, BranchNo → BranchAddress, OfficePhone, Name, Position, HoursPerWeekstaffNo → Name, Position BranchNo > BranchAddress, OfficePhone OfficePhone → BranchAddress