Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle 10g SQL

Authors: Joan Casteel, Lannes Morris Murphy

1st Edition

141883629X, 9781418836290

More Books

Students also viewed these Databases questions

Question

Is there anything you wished would come back into fashion?

Answered: 1 week ago