Ask
Login
0
7.0kviews
List all functional dependencies satisfied by the relation
written 8.5 years ago by gravatar for meghalikalyankar meghalikalyankar • 2.3k modified 3.0 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
0
258views
written 8.5 years ago by gravatar for meghalikalyankar meghalikalyankar • 2.3k

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
ADD COMMENT EDIT
Please log in to add an answer.