Ask
Login
0
7.3kviews
List all functional dependencies satisfied by the relation
written 10.2 years ago by gravatar for omkarthopate2111 omkarthopate2111 • 0 modified 4.6 years ago by gravatar for krithikkm200 krithikkm200 • 10
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
259views
written 10.2 years ago by gravatar for omkarthopate2111 omkarthopate2111 • 0

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.