Re: A simple Q from a beginner

Hugo wrote in message <8r7tui$13mu3_at_hkunae.hku.hk>...
>Dear All,
> If a doctor can prescribe several drugs for a patient. And a
>patient can take drugs from several doctors . How is the ER Diagram look
>like if every prescription of the same drug from the same doctor for the
>same patient are to be recorded, i.e. not only the latest prescription is
>recorded?
>
>thx a lot.
>
>

Greetings

One drug is prescribed by many doctors
One drug is taken by many patients

Below a some tables to start with, but by no means perfect.

V

TableDrugDetails

    DrugID(Primary Key)
    DrugDescription
    etc

TableDoctors

    DocID(Primary Key)
    DoctorName
    etc

TableClient

    ClientID(Primary Key)
    ClientDetails
    etc

PrescriptionDetails

    PrescriptionID (Primary Key)
    ClientID
    DoctorID
    PrescDate
    etc

PrescriptionMedication

    PrecriptionID
    DrugID Received on Sun Oct 01 2000 - 20:34:59 CEST