Database design question
From: Carlos Flor <cflor_at_dc.com>
Date: 17 Jun 2003 17:09:31 -0700
Message-ID: <d17cf246.0306171609.41cfbbb6_at_posting.google.com>
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 Wed Jun 18 2003 - 02:09:31 CEST
Date: 17 Jun 2003 17:09:31 -0700
Message-ID: <d17cf246.0306171609.41cfbbb6_at_posting.google.com>
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 Wed Jun 18 2003 - 02:09:31 CEST