I will just get right down to it. If I have these Entities/Tables.
1 - Clients
2 - Cases
3 - Invoices
Assuming all relationships are one-to-many. Which Figure is the right way.
Figure A - I can deduce which invoice is for which case, which case is for which client and therefore which invoice is for which client.
Figure B - I can not find out which invoice is for which Case. To solve this I have to make Figue C
Figure C - But this has now 2 relationships.
Is the Figure A not more accurate than Figure C