PrepAway - Latest Free Exam Questions & Answers

Which of the following is an important part of database…

Which of the following is an important part of database design that ensures that attributes in a table depend
only on the primary key?

PrepAway - Latest Free Exam Questions & Answers

A.
Normalization

B.
Assimilation

C.
Reduction

D.
Compaction

Explanation:
The first normal form (1NF) requires that we create separate tables for each group of related data and identify
each row with a unique column identified as the primary key. The second normal form (2NF) requires that we
move data that is only partially dependent on the primary key to another table. The third normal form (3NF)
requires that we remove data that do not depend only on the primary key. The process of conforming with the
normal form us called normalization.

Conrad, Eric, Seth Misenar and Joshua Feldman, CISSP Study Guide, 2nd Edition, Syngress, Waltham, 2012,
pp. 199-200


Leave a Reply