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