I am using sql server to create a database and I have many to many relationships and I am wondering if it is a good idea to connect all of them in one junction table or I must create a junction for only two tables.
I have 5 tables that are many to many and I have referenced them only with one junction table.
I am not sure if I will not be doing something that is not allowed by using one junction table for all the 5 tables. I am wondering also if I will be able to query the tables connected to that junction table.
You need one junction table per relationship