i am a student and i am making a database for a gym, i have an entity [members] and an entity [training classes], this is a N:M relationship so i have to make an intermediate table so my database is [members] 1------M [Intermediate table] N------1 [training classes], do you have any ideas what i have to put in intermediate table except from the 2 FK of the parent entities ?. want some ideas please!.
pikkas
0
Light Poster
Nige Ridd
0
Junior Poster in Training
Your intermediate table ONLY needs to contain the member and training class. You could include extra data if you wanted ( and if applicable ) like Dates of when the person applied/paid for the course, completion of the course, perhaps even their feedback on the course itself.
Nige
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.