Multiple choice

A goal of normalization is to __________

  1. minimize the number of relationships

  2. minimize the number of entities

  3. minimize the number of tables

  4. minimize the number of redundancy

  5. none of these

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Normalization in database design aims to minimize redundancy by organizing data efficiently and eliminating duplicate information. It does not minimize relationships, entities, or tables directly; these may increase during normalization. The phrasing should be 'minimize redundancy' but the intent is correct.