📝 Question
#1542
A table has fields F1, F2, F3, F4, and F5, with the following functional dependencies: F1->F3 F2->F4 (F1,F2)->F5
✓
Correct Answer
A. 1NF
💡
Explanation
Since the primary key is not given we have to derive the primary key of the table. Using the closure set of attributes we get the primary key as (F1,F2). From functional dependencies, “F1->F3, F2->F4”, we can see that there is partial functional dependency therefore it is not in 1NF. Hence the table is in 1NF.
⌨️ Press
A
B
C
D
to select