Courseiva
← FC0-U71
Full test
hardMultiple ChoiceObjective-mapped

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

A table has columns: EmployeeID (PK), DepartmentID, DepartmentName, Salary. Which normal form violation exists?

⚠ Common exam trap

A common mix-up: candidates confuse transitive dependencies with partial dependencies, leading them to incorrectly select Second Normal Form (2NF) instead of Third Normal Form (3NF).

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

✓

Third Normal Form

The table violates Third Normal Form (3NF) because DepartmentName depends on DepartmentID, which is not a candidate key. In 3NF, every non-key column must depend solely on the primary key (EmployeeID), not on another non-key column. This transitive dependency (EmployeeID → DepartmentID → DepartmentName) requires splitting the table into Employees and Departments to achieve 3NF.

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

    A 3NF violation exists.

  • ✗

    Second Normal Form

    Why it's wrong here

    There is no partial dependency because EmployeeID is PK and all non-key attributes depend on it.

  • ✗

    First Normal Form

    Why it's wrong here

    All values are atomic, so 1NF is satisfied.

  • ✓

    Third Normal Form

    Why this is correct

    Transitive dependency: DepartmentName depends on DepartmentID, not on EmployeeID.

About these practice questions

This FC0-U71 question is part of Courseiva's 988-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

JA

Written by Johnson Ajibi, MSc IT Security

Senior Network & Security Engineer · founder of Courseiva

This FC0-U71 practice question is part of Courseiva's free CompTIA certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the FC0-U71 exam.