Re: Hospital ERD

G'day Portroe

My knee jurk reaction would be to have a single table for staff with an attribute (in the staff table) that describes each staff member.  Tony

"Portroe" <fb_at_oooi.com> wrote in message news:bvp8e4$nf$06$1_at_news.t-online.com...
> Hi all,
>
> I am constructing an ERD for a complicated hospital project at present.
> Many components are straight forward , ie. Patient, Ward, Medication
> etc. However what I am finding difficult to cope with is how to fit the
> vast and varied staff of a hospital into an ERD,
>
> the options are have one table for Staff,(keeping things simple)
>
> or
>
> give each Type of staff member its own table, (making for a busy diagram)
>
> Has anybody got pros and cons of doing it either way,
>
> thanks
>
> Portroe
>
Received on Tue Feb 03 2004 - 21:48:41 CST