The whole purpose of separating data into separate tables in a relational database is to
A)provide the data in a format that can be analyzed using Excel.
B)enable the data to be cleansed.
C)simplify the process of importing data.
D)avoid redundancy.

Question

Quizplus · Accepted Answer

The primary reason for separating data into different tables in a relational database is to avoid redundancy, which helps in minimizing the duplication of data, ensuring data integrity, and optimizing storage space. This practice follows the principles of normalization.

The Whole Purpose of Separating Data into Separate Tables in a Relational