Another simple Q from a beginner

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 Sun Oct 01 2000 - 22:39:12 CEST