GATE 2023 Database Quiz 17

Which-one of the following statements about normal forms is FALSE?

In 1 NF an attribute of a table cannot hold?

The following functional dependencies are given:

AB → CD, AF → D, DE → F, C → G, F → E, G → A

Which one of the following options is false?

Consider the relational schema R(A B C D) with following functional dependency set F = {A → BC, C → D}; The relation R is in ______.

Consider the relational schema R(A B C D E) with following FD set F = {A → CE, B → D, AE → D}, Identify the highest normal form satisfied by the relation R?

Which of the following statements is incorrect?

S1: A relation in 3 NF must also be in BCNF

S2: A relation in 2NF must also be in 1NF