FC0-U71 Practice Question: A table has columns: EmployeeID (PK),…

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

• ✗

  No violation

  Why it's wrong here

  DepartmentName depends on DepartmentID rather than on the primary key EmployeeID, creating a transitive dependency that breaches Third Normal Form. It is tempting to assume a simple table is fine, but no violation would be correct only if every non-key column depended solely on EmployeeID.

• ✗

  Second Normal Form

  Why it's wrong here

  Second Normal Form concerns partial dependencies on part of a composite primary key; here the key is the single column EmployeeID, so no partial dependency exists. It is tempting because DepartmentName depends on DepartmentID, and 2NF would be the correct answer if the key were composite, such as EmployeeID plus ProjectID.

• ✗

  First Normal Form

  Why it's wrong here

  First Normal Form requires atomic values and no repeating groups; every column here holds a single value, so 1NF is satisfied. It is tempting because normalisation questions often start at 1NF, and it would be the correct answer if a column stored multiple values, such as several phone numbers in one field.

• ✓

  Third Normal Form

  Why this is correct

  DepartmentName depends on DepartmentID, not directly on the primary key EmployeeID, creating a transitive dependency. Third Normal Form eliminates such non-key attributes dependent on other non-key attributes, so the table violates 3NF. This satisfies the stem's requirement to identify the specific normal form breached by the redundant DepartmentName column.