0
1.2kviews
List all functional dependencies satisfied by the relation
A B C
A1 B1 C1
A1 B1 C2
A2 B1 C1
A2 B1 C3

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

Marks: 5M

Year: Dec 2013

1 Answer
0
2views

When a column (entity) can be fully determined by another column, then it is functional dependent on that column.

Following are all functional dependencies which are possible from above relation.

A → B

A → C

B → A

B → C

C → A

C → B

Out of these functional dependencies, following are the functional dependencies satisfied by the relation.

B → A

B → C

Please log in to add an answer.