The process of converting poorly structured tables into two or more well-structured tables is referred to as ________.
A)replication
B)normalisation
C)actualisation
D)integration

Question

Quizplus · Accepted Answer

The process described is known as normalisation. This involves breaking down a single table with redundant or incomplete data into two or more tables with well-defined relationships between them. This helps to improve data consistency, reduce data redundancy and improve data integrity. Replication involves copying data from one location or system to another, while actualisation and integration are not directly related to restructuring poorly structured tables.

The Process of Converting Poorly Structured Tables into Two or More