1,089 views

2 Answers

10 votes
10 votes

Yes. Actually this shouldn't be a question if one understands the meaning of "trivial". Trivial basically means "the question has no need". One example of a trivial property is:

  • Do human beings have brain?
There is no need to answer this question as it is trivially true- because all human beings have brain. 
Now a non-trivial property would be 
  • Do human beings have intelligence?
Now, this need not be true for all human beings and hence non-trivial. 
 
Now, coming to functional dependency we say A- > B, when the same A element always causes the same B element. i.e., whenever A element repeats B element also repeats. If A is a composite set (x,y) coming from attributes X and Y and B is the attribute Y (hence B ⊂ A), we are sure than whenever the A element repeats the B element also repeats. That is, the functional dependency cannot be violated whatever be the elements - hence TRIVIAL. 

Related questions

2 votes
2 votes
2 answers
2
gatecrack asked Dec 10, 2018
581 views
Is minimal set of functional dependency for a functional dependency set is always unique???
0 votes
0 votes
1 answer
3
Raghav Khajuria asked Oct 5, 2018
882 views
Difference between composite and compound key??
1 votes
1 votes
0 answers
4
iarnav asked Nov 24, 2017
738 views
consider:T1: {A11, A12, A13} - key is A11T2: {A21, A22, A11} - key is A21T3: {A21, A23} - key is {A21 A23}T1, T2, T3 all are in which normal form? a) 2nfb) 3nfc) BCNFFUNC...