Re: How can one normalize this table?

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