_____ improves database efficiency by eliminating redundant data and ensuring that only related data is stored in a table.
A)Optimization
B)Fragmentation
C)Normalization
D)Encapsulation

Question

Quizplus · Accepted Answer

Normalization is a process that helps to improve database efficiency by eliminating redundant data and ensuring that only related data is stored in a table. This reduces data redundancy and inconsistency and improves data integrity, making it easier to manage and maintain the database. Optimization refers to the process of tuning the database and its components to improve performance, while fragmentation refers to the splitting of data into multiple fragments for storage. Encapsulation refers to the process of hiding the complexities of a system by encapsulating its internal workings within a set of interfaces. None of these processes are directly related to improving database efficiency through data normalization.

_____ Improves Database Efficiency by Eliminating Redundant Data and Ensuring