Identify the aspect of a normalized database that is incorrect:
A)Data is consistent.
B)Redundancy is minimized and controlled.
C)All data is stored in one table or relation.
D)The primary key of any row in a relation cannot be null.

Question

Quizplus · Accepted Answer

In a normalized database, all data is not stored in one table or relation. Instead, data is divided and stored in multiple related tables or relations to minimize redundancy and improve consistency. This is known as normalization. Choice C contradicts this fundamental principle of database normalization.

Identify the Aspect of a Normalized Database That Is Incorrect