Re: One to One Relationship

"Peter" <no_email_at_no_email.com> wrote:
>
> How else would you model this? Both entities, employees and departments
> are completely different and thus you couldn't put them in the one table.
> Maybe the database books that I have been reading have been incorrect or
> has database theory changed recently?
>
> 1 1
> |employee| --- <manages> --- |department|

So not only does each department have exactly on manager, but each employee manages exactly one department? That's an odd corporate structure.

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service              New Rate! $9.95/Month 50GB