+1 vote
64 views
in Database Management Systems by

1 Answer

+1 vote
by
selected by (user.guest)
 
Best answer

As well as identifying Fds which hold for all possible values of the attributes involved in the fd, we also want to ignore trivial functional dependencies. A functional dependency is trivial if, the consequent is a subset of the determinant. In other words, it is impossible for it not to be satisfied.  

Example: Using the relation instances, the trivial dependencies include:

{ staff#, sname} → sname

{ staff#, sname} → staff#

Although trivial Fds are valid, they offer no additional information about integrity constraints for the relation. As far as normalization is concerned, trivial Fds are ignored.

Related questions

+3 votes
1 answer 305 views
+1 vote
0 answers 11 views
+1 vote
1 answer 25 views
+1 vote
1 answer 28 views
+1 vote
1 answer 29 views
+1 vote
1 answer 39 views
0 votes
1 answer 71 views
+1 vote
1 answer 34 views
0 votes
1 answer 57 views
asked Oct 25 in Database Management Systems by (user.guest)
0 votes
1 answer 77 views
asked Sep 23 in Database Management Systems by (user.guest)
+1 vote
1 answer 68 views
asked Sep 23 in Database Management Systems by anonymous
+1 vote
1 answer 138 views
+1 vote
1 answer 183 views
+1 vote
1 answer 372 views
+1 vote
1 answer 63 views
+1 vote
1 answer 86 views
+1 vote
1 answer 80 views
+1 vote
1 answer 200 views
+1 vote
1 answer 308 views
+1 vote
1 answer 52 views
0 votes
2 answers 267 views
+2 votes
1 answer 143 views
asked Aug 14 in Database Management Systems by (user.guest)
+1 vote
1 answer 221 views
asked Sep 22, 2020 in Database Management Systems by (user.guest)
+1 vote
1 answer 259 views
+2 votes
1 answer 913 views
+1 vote
1 answer 1.3k views
+2 votes
1 answer 1.4k views
+1 vote
1 answer 90 views
+1 vote
1 answer 68 views
+1 vote
1 answer 150 views
0 votes
1 answer 62 views
0 votes
1 answer 61 views
+1 vote
1 answer 81 views
+1 vote
1 answer 71 views
+1 vote
1 answer 81 views
+1 vote
1 answer 75 views
+1 vote
1 answer 185 views
+1 vote
1 answer 177 views
Welcome to CPENTalk.com
Solution-oriented students of computer engineering on one platform to get you that

ONE SOLUTION

...