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.