Pakistan's best MCQs practice hub — FPSC · PPSC · CSS · NTS · Other Exams
Login

Which Normal Form eliminates partial dependency by ensuring that all non-key attributes are fully functionally dependent on the entire primary key?

AFirst Normal Form (1NF)
BSecond Normal Form (2NF)
CThird Normal Form (3NF)
DBoyce-Codd Normal Form (BCNF)

Explanation

2NF requires the table to be in 1NF and have no partial dependencies (non-prime attributes depending on only part of a composite primary key). 3NF eliminates transitive dependencies.

Exam Relevance
  • Topic: Database Management Systems
  • Subtopic: Database Normalization
Submitted by: mcqstutor Team More Computer MCQs →

No Comments

Leave a comment

Your email address will not be published. Required fields are marked *