Databases MCQ with Answers

In BCNF

in 3NF, but not in BCNF

In 2NF, but not in 3NF

Not in 2NF

A —> BC and B ---->C

A ----> BC and AB —> C

A —> BC and A —> B

A —> B and B —> C

2NF

3NF

4 NF

BCNF

y⊆x

y⊂x

x⊂y

x⊂y and y⊂x

First normal form

Second normal form

Third form

Fourth normal form