Consider the following table : The table is in which normal form?
2014
Consider the following table :
The table is in which normal form?
- A.
First Normal Form
- B.
Second Normal Form
- C.
Third Normal Form but not BCNF
- D.
Third Normal Form but BCNF
Attempted by 431 students.
Show answer & explanation
Correct answer: C
Determining the normal form involves checking functional dependencies. The table satisfies 1NF (atomic values) and 2NF (no partial dependencies). It satisfies 3NF but violates BCNF, as the determinant is not a superkey. Thus, the correct classification is Third Normal Form but not BCNF.
Answer : C
Dependency:
AB ---> CDE
C ---> B
CK : AB and AC
BCNF : Not in BCNF since C is not a SK in C-->B.
3NF : It's in 3NF since there's no CK that can transitively determine any Non-Prime attribute.