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

ID: 3867315 • Letter: L

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

Here the table has the following columns

The non trivial dependencies are

here the NIN->Contract No

NIN->Ename

it is non trivial because contact no uniquely depends on NIN(NIN is not subset of Contact no)

But the Trivial dependencies includes

{NIN,ContactNo}->Hno

here the contact no ,Hno,Hloc are the subset of the NIN

Navigate

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

List the number of groups and bonding groups on the central atom of each of the

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

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

Question

Explanation / Answer

Related Questions

Navigate