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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!