A student database table has columns: StudentID, StudentName, StudentAddress,...
Ola technical mcq question, verified with a worked answer. Free to practise - no sign-up.
A student database table has columns: StudentID, StudentName, StudentAddress, StudentPhoneNumber. If the table is prone to update and insertion anomalies due to transitive dependencies, which normal form should the table be brought to?
Show answer & explanation
Answer: A. Fourth Normal Form (4NF)
Accurate technical and quantitative evaluation based on foundational principles.
Step-by-step Derivation:
Step 1: Formulate problem conditions.
Step 2: Apply logical deduction.
Step 3: Conclude correct option.