Re: Another simple Q from a beginner

Prescription have already a datefield to keep them apart.

Hugo wrote:

> Dear All,
> Here's a simple Q about the a database design :
> 1)every patient has a primary physcian. every physcian can have several
> patients.
> 2)physcian prescribe drugs for patients.a physcian can prescribe one or more
> drugs for several patients and a patient can obtain prescriptions from
> several doctors. each prescription has a date and a quantity associated with
> it.
>
> So could u pls tell me how to draw the ER disgram or tableif a doctor
> prescribes the same drug for the same patient more than once, several such
> prescriptions have to be recorded.
>
> thx a lot !!
  Received on Mon Oct 02 2000 - 11:39:03 CEST