Re: Hospital ERD

From: Peter Mount <info_at_petermount.au.com>
Date: Wed, 4 Feb 2004 20:12:50 +1000
Message-ID: <4020b5e7_1@news.iprimus.com.au>

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 - 04:12:50 CST