[thelist] Database Normalization Question

Paul Backhouse paul.backhouse at 2cs.com
Wed May 15 07:09:00 CDT 2002

you could have one table for the user, one for the sections and one linking
the users with the sections.


UserID   UserName
1        Fred Bloggs
2        Joe Bloggs

SectionID    SectionName
1            Marketing
2            Production
3            Sales

SectionID   UserID
1           1
2           1
3           1
1           2
3           2

So User Fred Bloggs is all available sections where as Joe Bloggs is in
Marketing and Sales section.

Doe this help - is this what you were after?



-----Original Message-----

Let me try to make myself more clear.

I have contact information for people in a company that work in multiple
areas.  I will create web pages that will display each area separately. An
employee could work in more than one area.

Does that explain things better?


More information about the thelist mailing list