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

Database Management System

1 Answer
0
219views

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.