Database MCQ

1:

A table has fields F1, F2 , F3 , F4, F5 with the following functional dependencies
Fi —> F3,
F2 —> F4
(FI,F2) —> F5

In terms of normalization, this table is in

A.

1 NF

B.

2 NF

C.

3 NF

D.

None of these

 

Answer : A

Explanation :

Primary key (candidates key) for this relation is [F1] [F2] because [F1, F2] column contains [F1, F2, F3, F4, F5]
So, there is, functional dependency F1 -> F3 , F2
It also have partial depedency so it is not in 2nd, 3rd NF.

Write your comments here:


Report Error
 

Option: A

Explanation : Explanation will come here. Explanation will come here. Explanation will come here. Explanation will come here. Explanation will come here.