Database design question
Posted: Wed Feb 18, 2004 12:43 pm
I am having hard time with one attribute in the following schema:

I am talking about managerID which is a part of Department table right now. Normally there should be Foreign key relationship between managerID and userID in CMSUser table. But if I set up this relationship, I am not able to fill tables. If I fill CMSUser first, I do need a departmentCode. Then again if I fill the Department first, what do I put for managerID of CMSUser is empty.
I would appreciate if someone gives me a hint on how I can resolve this.
Thank You,
Sabina

I am talking about managerID which is a part of Department table right now. Normally there should be Foreign key relationship between managerID and userID in CMSUser table. But if I set up this relationship, I am not able to fill tables. If I fill CMSUser first, I do need a departmentCode. Then again if I fill the Department first, what do I put for managerID of CMSUser is empty.
I would appreciate if someone gives me a hint on how I can resolve this.
Thank You,
Sabina