0
11kviews
Consider the following relation
A B C Tuple #
10 b1 C1 #1
10 b2 C2 #2
11 b4 C1 #3
12 b3 C4 #4
13 b1 C1 #5
14 b3 C4 #6

Given the previous state which of the following dependencies may hold in the above relation?

If the dependency cannot hold explain why by specifying the tuples that cause the violation:-

I. A → B

II. B → C

III. C → B

IV. B → A

V. C → A

1 Answer
0
931views

What does X → Y mean? It means, Y is functionally dependent on X.

Remember this trick “Keep Y value same and check if X is same too. If not, relation doesn’t hold.”

I. A → B

This dependency cannot hold, because A → B implies that A can uniquely …

Create a free account to keep reading this post.

and 3 others joined a min ago.

Please log in to add an answer.