Hello! I am fairly new to DB design and I have run into a problem. I
have a list of employees for a company. Each employee can have
several roles. EAch role is composed of several activities and each
activity is composed of several steps. Now, each step can belong to a
number of activities and each activity can belong to a number of
roles, etc... Is the best way to do this to have separate tables for
step, act, role, and employee and then have a new table that would
like like: newPK, stepID(fk), actId(fk), roleID(fk), empID(fk)? I
can't figure out how I can form relationships between all of this
data. I want to be able to take a person and be able to find out what
act's they have, or what roles, or what steps and any combination of
those things. Can anyone help? Thanks and i hope that makes sense.
Received on Tue Jun 17 2003 - 19:09:31 CDT
