- Apr 22, 2001
- 1,544
- 0
- 76
I'm kinda stumped on a question for school....here's that part I'm stuck at.
"A student club wants to have a database to manage its data on members. The club assigns members to its numerous committees. It is possible that one member can servie in more than one committe and will chair at most one commitee."
So far I've made two tables students and committees. Those two table have a many-to-relationship because a committee can have many students and a student can belong to many committees. How would I go about doing the part where a member can chair only one committee part. I'm almost positive it's a one-to-one relationship I just don't know where to put it.
"A student club wants to have a database to manage its data on members. The club assigns members to its numerous committees. It is possible that one member can servie in more than one committe and will chair at most one commitee."
So far I've made two tables students and committees. Those two table have a many-to-relationship because a committee can have many students and a student can belong to many committees. How would I go about doing the part where a member can chair only one committee part. I'm almost positive it's a one-to-one relationship I just don't know where to put it.