Nielit nov 2018

Question

Consider the following functional dependency in a database

A-->B

B-->C

D-->E

E-->D

F-->G

F-->H

(E,F)-->I

The relation (E,D,A,B) IS:

• A. 2NF
• B. 3NF
• C. BCNF
• D. NONE OF ABOVE

Comments

D) none of these.

As it is in $1NF$ because the relation $R(E,D,A,B)$ has CK as $AE$ and $AD$. and FDs = ${\{A \rightarrow B, E \rightarrow D, D \rightarrow E}\}$

Answer 1

D