Question

Which of the following is NOT true regarding redundancy?

1) Redundancy occurs when data is repeated several times in a database.
2) When you normalize a database, you eliminate redundancy.
3) Foreign keys are redundant, but no other data about the entity is repeated.
4) Normalization is the process of minimizing duplicate data.

Answer 1

Redundancy is the repetition of data in a database. Normalization eliminates redundancy and minimizes duplicate data.

Step-by-step explanation:

The correct answer is option 3. When it comes to redundancy, it means that the same data is stored multiple times in a database. In option 1, redundancy is correctly defined as data repetition. Option 2 is also true because normalization is the process of organizing data in a database to minimize redundancy. However, option 3 is incorrect because foreign keys are not redundant, they are used to establish relationships between tables in a database. Option 4 is true because normalization is indeed the process of minimizing duplicate data.