One goal of normalization is to make ________.
A) duplicate copies of essential information
B) primary keys correspond to all tables
C) data hierarchically dependent
D) data functionally dependent

Question

Quizplus · Accepted Answer

The goal of normalization is to eliminate redundancy and dependency in data by breaking down data into smaller, more manageable tables. This is done by ensuring that each table has a primary key and that all other data in the table is functionally dependent on that key. Option A is incorrect as duplication of information is avoided in normalization. Option B is not a goal of normalization but rather a requirement for a table to be properly normalized. Option C is not a goal of normalization but rather a characteristic of a hierarchical data model.

One Goal of Normalization Is to Make ________