________ in a well-structured relational database.
A)Every table must be related to all other tables
B)One table must be related to at least one other table
C)Every table must be related to at least one other table
D)One table must be related to all other tables

Question

Quizplus · Accepted Answer

In a well-structured relational database, every table must be related to at least one other table to ensure data consistency and integrity. However, it is not necessary for every table to be related to all other tables. This would result in a complex and inefficient database design. Similarly, it is not mandatory for one table to be related to all other tables, as this would also lead to redundancies and data inconsistencies. Option B does not provide enough information about the interrelationships between tables, which could lead to data anomalies. Therefore, option C is the best choice.

________ in a Well-Structured Relational Database