PrepAway - Latest Free Exam Questions & Answers

Normalizing data within a database includes all of the following except which?

Normalizing data within a database includes all of the following except which?

PrepAway - Latest Free Exam Questions & Answers

A.
Eliminating repeating groups by putting them into separate tables

B.
Eliminating redundant data

C.
Eliminating attributes in a table that are not dependent on the primary key of that table

D.
Eliminating duplicate key fields by putting them into separate tables

Explanation:
“Data Normalization
Normalization is an important part of database design that ensures that attributes in a table
depend only on the primary key. This process makes it easier to maintain data and have
consistent reports.
Normalizing data in the database consists of three steps:
1.)Eliminating any repeating groups by putting them into separate tables
2.)Eliminating redundant data (occurring in more than one table)
3.)Eliminating attributes in a table that are not dependent on the primary key of that table”
Pg. 62 Krutz: The CISSP Prep Guide: Gold Edition


Leave a Reply