Re: DBDesign Q2:
From: Andy <net__space_at_hotmail.com>
Date: 27 Nov 2003 20:09:30 -0800
Message-ID: <edb90340.0311272009.7b41ebc7_at_posting.google.com>
Date: 27 Nov 2003 20:09:30 -0800
Message-ID: <edb90340.0311272009.7b41ebc7_at_posting.google.com>
"Vlad Vissoultchev" <wqweto_at_nospam.myrealbox.com> wrote in message news:<uCXMLGStDHA.2060_at_TK2MSFTNGP10.phx.gbl>...
> > Solution B: (I think it is cleaner than A, but there is a whole)
> > Department (DepartmentID PK, Name)
> > Employee (EmployeeID PK , Name, ., dDepartmetnID FK)
> > (the next is subtyping of employee)
> > DepartmentMngr(EmployeeID PK/FK, dDepartmentID FK/U1)
> >
> > It will satisfy bus. rule, but there is a whole.
> > Employee who is a manager can reference one department in Employee
> > table and the other department in DepartmentMngr.
>
> it's not clear what's the FK on DepartmentMngr refers to.
DepartmentMngr.dDepartmentID refers Department.DepartmentID Received on Fri Nov 28 2003 - 05:09:30 CET