What will be the relationships between entities?

Question

Database design

How to make connections?

Answer 1

You design from relationships in the database
Your diagram shows that everything is connected to everything ... this is a bad approach, they usually design from business processes and already within them they find entities and relationships ...
And yes, some entities are only connected to others by id, but they don’t fit into the database, yes, it’s not as rigid and connected as tying everything through FK at the database level, but it’s more convenient and easier (the experience of decades of approaches and sores of large projects speaks of this)
Try to develop it through the code, maybe everything is already difficult for you