help on database modeling problem!

•

What is DaniWeb IT Discussion Community?

You're currently browsing the Database Design section within the Web Development category of DaniWeb, a massive community of 430,097 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,151 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our Database Design advertiser: Programming Forums

Thread Tools Display Modes

Views: 525 | Replies: 1

•

Join Date: Dec 2007

Posts: 18

Reputation: pikkas is an unknown quantity at this point

Rep Power: 1

Solved Threads: 0

pikkas

Offline

Newbie Poster

help on database modeling problem!

Jan 8th, 2008

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

•

Join Date: Nov 2007

Posts: 51

Reputation: Nige Ridd is an unknown quantity at this point

Rep Power: 1

Solved Threads: 9

Nige Ridd

Offline

Junior Poster in Training

Re: help on database modeling problem!

Jan 9th, 2008

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