The general goal of normalisation is to ________.
A)convert two or more tables into a single table
B)create a copy of an existing table
C)construct tables such that every table has a single topic
D)construct tables such that all tables have a similar topic

Question

Quizplus · Accepted Answer

The goal of normalization is to eliminate redundancy and ensure that each table has a single topic, which helps to prevent data inconsistencies and anomalies. Option A is incorrect because Normalization does not necessarily require merging tables into a single table. Option B is incorrect because the goal of normalization is not to create a copy of an existing table. Option D is incorrect because tables with different topics should not be combined into a single table during normalization.

The General Goal of Normalisation Is to ________