Group Membership - One-to-Many Dilemma
From: Yael <yaelr_at_locus.com.au>
Date: 19 Dec 2002 19:50:04 -0800
Message-ID: <7a808e4e.0212191950.37f19239_at_posting.google.com>
I'd like to pick your brains on the correct way to approach this situation:
Date: 19 Dec 2002 19:50:04 -0800
Message-ID: <7a808e4e.0212191950.37f19239_at_posting.google.com>
I'd like to pick your brains on the correct way to approach this situation:
I have Staff, Teams and Roles.
A team is made up of staff members in different roles.
Some roles are predefined, and every team must have these roles filled
(eg: every team must have a manager and a supervisor).
Other roles are user-defined and can be added to a team as required
So the Team to Member relationship is not simply one-to-many, it's one-to-two-or-more, which seems very ugly to me.
The membership table would be
Team Id*
Role*
Member (staff Id)
But which is better:
And the membership table for additional roles only
OR
2. Defining the Team table like this
Team Id*
Team Name
Your thoughts would be greatly appreciated! Yael Received on Fri Dec 20 2002 - 04:50:04 CET