DBMS - Normalization

Normalization works through a series of stages called normal forms. Typically ____ stages are processed.

• 2

• 3

• 4

• 5

1NF describes the tabular format in which all of the following are true except ____.

• all the key attributes are defined

• there are no repeating groups in the table

• all attributes are dependent on the primary key

• no attributes are dependent on the primary key

Data redundancy produces ____.

• slower lookups

• robust design

• efficient storage use

• data integrity problems

Normalization is a process for assigning ____ to entities.

• data

• files

• attributes

• relations

From a structural point of view, 2NF is better than ____.

• 1NF

• 2NF

• 3NF

• 4NF

____ yields better performance in simple data retrieval process.

• Denormalization

• Normalization

• Atomization

• Compression

Dependencies based on only a part of a composite primary key are called ____ dependencies.

• primary

• partial

• incomplete

• composite