Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2006
    Posts
    29

    clinic management database design

    I have concern for this 3 tables:

    Appointment
    -AppointmentID
    -PatientID
    -DoctorID
    -AppointmentDate

    Treatment
    -TreatmentID
    -PatientID
    -DoctorID
    -Treatment
    -TreatmentDate
    -Fees

    Visits
    -VisitID
    -DoctorID
    -PatientID
    -VisitDate

    The doctor can have 1 or more appointment. A patient can have 1 or more appointment. So the doctor and patient is associated through the appointment.

    The doctor can provide 1 or more treatment. Each patient receives 1 or more treatment. So the doctor and patient is associated through the treatment.

    The patient can go for 1 or more visits. A doctor can have 1 or more visits. The patient and doctor is associated through the visit.

    Therefore how can visits and appointment be associated with treatment?.
    Attached Thumbnails Attached Thumbnails ClassDiagram.gif  
    Last edited by solomon13000; 07-27-09 at 11:34.

  2. #2
    Join Date
    Oct 2006
    Posts
    29
    I carefully relook at my diagram and now I understand
    However is it advisable to have a status attribute inside the visit class?
    status: Arrived, Visited, Left

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •