Normalization of database is used to
-
Eliminate redundancy.
-
Improve security.
-
Improve efficiency.
-
Minimize Errors.
Normalization of a database is used to eliminate redundancy and improve efficiency.
A. Eliminate redundancy: This option is correct. One of the main goals of database normalization is to eliminate or reduce redundancy in order to improve data consistency and reduce storage requirements. Redundancy can lead to data inconsistencies and inefficiencies in data management.
B. Improve security: This option is not directly related to normalization. While normalization can indirectly improve security by ensuring data integrity and reducing the risk of data inconsistencies, it is not its primary purpose.
C. Improve efficiency: This option is correct. Normalization helps improve the efficiency of data storage, retrieval, and manipulation operations by organizing data into properly structured tables and reducing data redundancy. This can lead to faster and more efficient query execution.
D. Minimize errors: This option is partially correct. Normalization can help minimize errors by reducing redundancy and ensuring data consistency. However, it is not its sole purpose, as efficiency and elimination of redundancy are also important goals.
Therefore, the correct answer is:
A. Eliminate redundancy.
Normalization is a database design process that organizes tables and their relationships specifically to eliminate redundant (duplicate) data by splitting information into related tables connected via keys. While well-normalized data can indirectly aid efficiency or reduce certain error classes, its primary and defining purpose is removing data redundancy and the update anomalies that come with it, not directly improving security.