Identify the aspect of a well-structured 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

Storing all data in one table or relation violates the concept of normalization and can lead to data redundancy, inconsistencies, and difficulties in querying the database. A well-structured database should have multiple tables or relations that store related data, with each table representing a distinct entity or relationship.

Identify the Aspect of a Well-Structured Database That Is Incorrect