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

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

B.
The Order Detail table has conflicting cardinalities.

C.
The priority path must be defined.

D.
There is more than one possible path between the tables.

Explanation: