Date: Wed, 23 Oct 2002 16:08:58 GMT
"John" <google_at_tsn.cc> wrote in message
> I am new to database modelling and was wondering if any of you could
> help me.
> I have a description of what the database should support and so have
> to figure out the entities and relationships myself. It is of a
> medical clinic. Now the clinic has "supplies" of "surgical" and
> "non-surgical" items. From the description, both surgical and
> non-surgical supplies have exactly the same attributes, with itemNo
> the primary key. There is also another supply the medical clinic
> and that is "pharmaceuticals". This has a few attributes the same
> as reorder Level, quantity and cost but the primary key is drugNo.
> the surgical and non-surgical supplies each hold the same attributes
> including itemNo as both their primary keys and pharmaceutical
> supplies holds a few attributes that are the same as the surgical
> nonsurgical but has drugNo as the PK. SHould I combine surgical and
> nonsurgical with simply and attribute that tells whether nonsurgical
> or surgical.
> So i would have:
> clinic - supplies (itemNo,....reorder Level, flag (tell whether s or
> - pharmaceutical (drugNo....reorder Level etc)
> How can I go about modelling this??
> Any help would be greatly appreciated
For model ideas, visit http://www.databaseanswers.com
Daniel Received on Wed Oct 23 2002 - 18:08:58 CEST