Describe Relational Database Schemas and Normalization Techniques DATA-ENGINEERING-OPTIMIZE Practice Questions (Page 2)

Questions 6–8

1. 6foundation · medium

   A table stores customer contact information with a column 'PhoneNumbers' containing values like '555-1234, 555-5678'. Which option correctly identifies the 1NF violation and its fix?

   • AThe column contains non-numeric characters; convert the values to integers to satisfy 1NF
   • BThe column contains multiple values in a single cell; split it into separate rows or a related table
   • CThe column contains a dependency on the primary key; move it to a separate table to satisfy 1NF
   • DThe column contains duplicate values; remove the duplicates and keep only one phone number per customer
   Reveal Solution Discussion Select an answer first
2. 7foundation · medium

   A table has a composite primary key (StudentID, CourseID) and columns: StudentName, CourseName, and Grade. Which option correctly identifies the 2NF violation and the appropriate fix?

   • AGrade depends on the full composite key; keep it in the same table because it satisfies 2NF
   • BStudentName depends only on StudentID, and CourseName depends only on CourseID; split into separate Student and Course tables
   • CStudentName depends on CourseName; split the table to remove this transitive dependency
   • DThe table has no primary key; add a surrogate ID column to satisfy 2NF
   Reveal Solution Discussion Select an answer first
3. 8foundation · medium

   A table is in 3NF. Which condition, if true, would mean the table still violates Boyce-Codd Normal Form (BCNF)?

   • AA non-prime attribute is partially dependent on a composite primary key.
   • BA candidate key is composed of multiple attributes.
   • CA determinant that is not a candidate key determines another attribute.
   • DA non-prime attribute is transitively dependent on the primary key.
   Reveal Solution Discussion Select an answer first