I am just designing a DB with 4 tables and these tables have a many to many relationship with each other. So it's not just books and authors, but language A, B, C, D .How many intermediary tables will I need?
16? Or is it just one with 4 columns ?
I am a newbie and quite in despair, because I could not find any info on such a case. Please help.
I see this is not enough info.
There will be 4 languages like english, germangerman, austriangerman, swissgerman and it should be possible to query from all to all.
So as far as I learned RDBMS , this should be many to many relationships. So the questions is should I create for each pair of tables one intermediary table or would one table with 4 columns be enough?
language
may be a column with SET datatype.