Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

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

Big Data, Mining, And Analytics Components Of Strategic Decision Making

Authors: Stephan Kudyba

1st Edition

1466568704, 9781466568709

More Books

Students also viewed these Databases questions