List the non-trivial functional dependencies in the table shown in Figure 1. Sta

Question

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

Explanation / Answer

Solution:-

The non trivial functional dependencies is, if a functional dependency x-->y exists and y is not subset of x then it is called non trivial functional dependency.

In the given relation the non trivial functional dependencies identified are given below -

NIN --> eName

contractNo --> hNo, hLoc

eName, contractNo --> hours

The above given functional dependencies are non trivial as all dependencies holds and no right side is subset of left side. So the functional dependencies identified in the given relation are non trivial functional dependencies.

Note - The given relation is not normalized as there are some values are repeated. If we decompose this relation and normalize it then we get some other functional dependencies.

Related Questions

Navigate

• Browse (All)
• Browse L
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.