Answered step by step
Verified Expert Solution
Question
1 Approved Answer
An agency called Instant Cover supplies part-time/temporary staff to hotels within Scotland. The table displays sample data, which lists the time spent by agency staff
An agency called Instant Cover supplies part-time/temporary staff to hotels within Scotland. The table displays sample data, which lists the time spent by agency staff working at various hotels. The National Insurance Number (NIN) is unique for every member of staff. (3 points) 2. (a) Identify the functional dependencies represented by the attributes shown in the table. Identify primary keys in your relations. (b) Describe and illustrate the process of normalizing the table to 3NF. Be specific for the process of Normalization. NIN contractNo hours eName hNo hLoc 1135 C1024 1057 C1024 1068 C1025 1135 C1025 16 SmithJ H25 East Kilbride 24 Hocine D H25 East Kilbride 28 White T H4 Glasgow 15 Smith J H4 Glasgow
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