Re: How can one normalize this table?

From: Jon Heggland <heggland_at_idi.ntnu.no>
Date: Thu, 15 Dec 2005 10:37:11 +0100
Message-ID: <MPG.1e0b57b232222a4b98974c_at_news.ntnu.no>


In article <1134619558.077407.164330_at_f14g2000cwb.googlegroups.com>, dawnwolthuis_at_gmail.com says...
>
> If I understand the requirements correctly, there is no need for an
> e-o-p base table. Position can be an attribute in the employee table.
> Then you need only an employee-office relationship table.

If you do it this way, you'll need a multi-table constraint to implement the FD { p, o } -> { e }.

-- 
Jon
Received on Thu Dec 15 2005 - 10:37:11 CET

Original text of this message