GO Classes DPP | Databases | Normalization | ISRO

Answer 1

fds = AB➡CDE , C➡B

candidate keys = AB , AC

non-prime attributes = D, E

It is in 3 NF (no violation)

Not in BCNF ( violation-  C➡B )

option C

Answer 2

Dependency:
AB ---> CDE
C ---> B
$1$NF(yes): assume all attributes are atomic
$2$NF(yes): no partial functional dependency like A alone can derive C or D or E
$3$NF(yes): no transitive functional dependency or there is nothing like (non key)-->(non key)

BCNF(no): in non trivial FD C-->B, C is not a SuperKey.

Underline is used to indicate Primary Key, Not candidate key.

Here, by underline, it means that $A B$ is a primary key. There can be more candidate keys.

Answer 3

C