That is confusing.

Ideally, each table would relate to one other table.

Yes, multiple junction tables might be the best approach.



Reporting several many side data often requires subreports.