Ask
Login
1
18kviews
List all functional dependencies satisfied by the relation.
written 9.5 years ago by gravatar for meghalikalyankar meghalikalyankar • 2.3k modified 3.9 years ago by gravatar for pedsangini276 pedsangini276 • 4.8k
a b C
A1 B1 C1
A1 B1 C2
A2 B1 C1
A2 B1 C3

Database Management System
database management systems
ADD COMMENT EDIT
1 Answer
2
2.5kviews
written 9.5 years ago by gravatar for meghalikalyankar meghalikalyankar • 2.3k

1. The functional dependencies satisfied by the relation are as follows:

i. A → B

For the tuples t1(A1,B1,C1) and t2(A1,B1,C2), t1 (A) =t2(A)=A1 and t1(B)=t2(B)=B1. Thus, the functional dependency A→B is satisfied by the relation.

ii. C → B

For the tuples t1(A1,B1,C1) and t3(A2,B1,C2), t1 (C) =t3(C) =C1 …

Create a free account to keep reading this post.

and 4 others joined a min ago.

ADD COMMENT EDIT
Please log in to add an answer.