Member Avatar for pikkas

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!.

  • 2 Contributors
  • 1 Reply
  • 82 Views
  • 15 Hours Discussion Span
  • Latest Post Latest Post by Nige Ridd
Member Avatar for Nige Ridd

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.