Question: The table shown below lists the time spent by the staff working at different branches of the restaurant. The National Insurance Number (NIN) is unique

The table shown below lists the time spent by the staff working at different branches of the restaurant. The National Insurance Number (NIN) is unique for employee contractNo hourper Week eName NIN 1135W C24 2341X C24 7122Y C25 1135W C25 rest Location Mong Kok Mong Kok Central Central rest No R25 16 30 21 John Chan Davis Hung R25 Cathy Wong R4 John Chan R4 Employee of Corby and their contracts to work at hotels a) The above table is susceptible to update anomalies. Provide examples of insertion, deletion, and modification anomalies. b) Draw the dependency diagram of table above. c) Normalize the table above to 3NF. State any assumptions you make about the data shown in this table
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
