Ask
Login
0
3.2kviews
List all functional dependencies satisfied by the relation.
written 9.0 years ago by gravatar for teamques10 teamques10 ★ 70k modified 3.8 years ago by gravatar for pedsangini276 pedsangini276 • 4.8k

Mumbai University > Information Technology > Sem 3 > Database Management System

Marks: 5M

Year: May 2015
database management systems
ADD COMMENT EDIT
1 Answer
0
73views
written 9.0 years ago by gravatar for teamques10 teamques10 ★ 70k •   modified 9.0 years ago

The functional dependencies satisfied by the relation are as follows:

  • 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.

  • C → B

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

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.