Multiple choice technology enterprise content management

In a transitive relationship scenario, what problems exist when reporting from the tables below?

  1. The Order table must be included in each query.

  2. The Order Detail table has conflicting cardinalities.

  3. Outer joins are generated when querying from Customer.

  4. There is more than one possible path between the tables.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

A transitive relationship or loop in database modeling creates multiple path options when joining tables (e.g., Joining A to C directly vs A to B to C). This ambiguity causes query generation issues because reporting engines have more than one possible join path to retrieve the data.

Keep practicing — related questions