Q75

MCQ2 marks, −0.5

A relation $\text{Empdtl}$ is defined with attributes empcode (unique), name, street, city, state and pincode. For any pincode, there is only one city and state. Also, for any given street, city and state, there is just one pincode. In normalization terms, $\text{Empdtl}$ is a relation in

(A)

$\textsf{1NF}$ only

(B)

$\textsf{2NF}$ and hence also in $\textsf{1NF}$

(C)

$\textsf{3NF}$ and hence also in $\textsf{2NF}$ and $\textsf{1NF}$

(D)

$\textsf{BCNF}$ and hence also in $\textsf{3NF}$ , $\textsf{2NF}$ and $\textsf{1NF}$

Loading…