On May 23, 12:34 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
> pietro...@gmail.com wrote:
> > Suppose I have records modeling users. Each user can be a member of
> > any number of groups (like how a unix user can be a member of any
> > number of groups). Whats the best way to implement this?
>
> > I think I would prefer if it was possible to have an enum field in the
> > user table which could store multiple values per record (one per
> > group) but the only practical way I can think to do it is to create
> > tables for each group and store the users primary key in the tables
> > corresponding to their group membership.
>
> > Following me? Any better ideas?
>
> Google for "database normalization" - it should help.
>
> You need a table which contains two columns - a group id and a user id.
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstuck...@attglobal.net
> ==================

They would form a joint primary key then. Does that mean that
selecting All users in a group and All groups of a user would be
equally efficient?