Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

List the non-trivial functional dependencies in the table shown in Figure 1. State any assumptions you make about the data shown in this table. 15

image text in transcribed

List the non-trivial functional dependencies in the table shown in Figure 1. State any assumptions you make about the data shown in this table.

15 points] An agency called Instant Cover supplies part-time/temporary staff to hotels within Scotland. The table shown in Figure 1 lists the time spent by agency staff working at various hotels. The National Insurance Number (NIN) is unique for every member of staff. NIN | contract o | hours | eName hNo hLoc 1135 C1024 1057 C1024 1068 C1025 1135 C1025 16 Smith H25 East Kilbride 24 Hocine D H25 East Kilbride 28 White T H4 Glasgow 15 SmithH4 Glasgow Figure 1: Instant Cover's contracts

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

Databases DeMYSTiFieD

Authors: Andy Oppel

2nd Edition

0071747990, 978-0071747998

More Books

Students also viewed these Databases questions

Question

main.py Load default template... user _ num = int input ( )

Answered: 1 week ago