(a) Consider the relation scheme R(A, B, C) with the following functional…

PYQ GATE 1995

(a) Consider the relation scheme R(A, B, C) with the following functional dependencies:

A, B → C, C → A

Show that the scheme R is the Third Normal Form (3NF) but not in Boyce-Code Normal Form (BCNF).

(b) Determine the minimal keys of relation R.

Sign up free to check your answer

Sign up free

Explore the full course: Zero To Hero

Loading lesson…