Relational databases are designed to reduce redundancy by
A) not allowing more than 5 fields per table.
B) ensuring that the primary key is not null.
C) referencing needed data already stored in a different table.
D) storing duplicate data in foreign keys.

Question

Quizplus · Accepted Answer

Relational databases reduce redundancy by referencing needed data already stored in a different table, rather than duplicating it. This is achieved through the use of foreign keys that reference primary keys in other tables, ensuring data consistency and minimizing storage space.

Relational Databases Are Designed to Reduce Redundancy by