Answered step by step
Verified Expert Solution
Question
1 Approved Answer
NIN 113567WD 234111XA 712670YD 113567WD contractNo C1024 C1024 C1025 C1025 Exercise 3 hours PerWeek Name 16 John Smith 24 Diane Hocine 28 Sarah White 16
NIN 113567WD 234111XA 712670YD 113567WD contractNo C1024 C1024 C1025 C1025 Exercise 3 hours PerWeek Name 16 John Smith 24 Diane Hocine 28 Sarah White 16 John Smith hotelNo H25 H25 hotelLocation Edinburgh Edinburgh Glasgow Glasgow H4 Figure 2: Employees of InstantCover and their contracts to work at hotels An agency called InstantCover supplies part-time/temporary staff to hotels throughout Scotland. Following table shows time spent by agency staff working at Two hotels. National Insurance Number (NIN) uniquely identifies each employee. Convert the table to 2NF and 3NF. NIN 113567WD 234111XA 712670YD 113567WD contractNo C1024 C1024 C1025 C1025 Exercise 3 hours PerWeek Name 16 John Smith 24 Diane Hocine 28 Sarah White 16 John Smith hotelNo H25 H25 hotelLocation Edinburgh Edinburgh Glasgow Glasgow H4 Figure 2: Employees of InstantCover and their contracts to work at hotels An agency called InstantCover supplies part-time/temporary staff to hotels throughout Scotland. Following table shows time spent by agency staff working at Two hotels. National Insurance Number (NIN) uniquely identifies each employee. Convert the table to 2NF and 3NF
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started