________ is the process of minimizing the duplication of information in a relational database through effective database design.
A)Formatting
B)Defining keys
C)Establishing relationships
D)Normalization

Question

Quizplus · Accepted Answer

Normalization is the process of eliminating redundant data and minimizing data dependence. This is achieved by dividing large tables into smaller entities and defining relationships between them. By doing so, data is stored only once, which reduces storage space requirements and ensures that data is consistent and up-to-date. Defining keys and establishing relationships are important steps in achieving normalization, but they are not the same as normalization itself. Formatting, while important for data presentation, is not directly related to reducing information duplication in a relational database.

________ Is the Process of Minimizing the Duplication of Information