Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ASP_DRUG_DEALER
Yak Posting Veteran
61 Posts |
 Posted - 2001-08-21 : 19:17:23
|
| Hey all- Design Question....I have a table called CONTRACTS. For each CONTRACT there is going to be three types of managers (ADMIN, GENERAL, ESTIMATOR). However, each manager is an EMPLOYEE (and of course in the employee table). How would you guys go about creating this relationship between these two entities?Should I create a 1:1 between EMPLOYEE and CONTRACT_ADMINS (new table)? Then create a 1:N between CONTRACT_ADMINS and CONTRACTS (one contract admin can manage many contracts)? Then do the same for the two remaining types of managers?Why do I feel this is kind of overkill? Oh yea, anyone know of a good data design group?Any help would be great!Thanks,ASP_DRUG_DEALER |
|
|
|
|
|
Three different types of managers per contract??