Re: Hospital ERD

Hello

One table for staff. Have a look up table (or more tables) for what they do. The theory being it's best to keep related data in only one table eg staff names

Peter Mount
info_at_petermount.au.com

"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 Wed Feb 04 2004 - 11:12:50 CET