NRM Q.2

Home
NRM Q.2

2A 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

Option : 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 has partial dependency so it is not in 2nd, 3rd NF.

Forgot your password?

I agree with the Terms.