Redundant relationships in a database design:
A) Can be derived from other relationships
B) Cannot be identified by reviewing the ERD
C) Should always be removed from the database design
D) None of the above

Question

Quizplus · Accepted Answer

Redundant relationships in a database design can be derived or inferred from other relationships, and are often unnecessary and should be removed. However, they can be difficult to identify by simply reviewing the ERD, as they may not be explicitly shown but rather implied through other relationships. Therefore, it is important to carefully analyze the entire database design to identify and eliminate any redundant relationships.

Redundant Relationships in a Database Design