Physician and Patient.

Added on - 16 Sep 2019

  • 7

    Pages

  • 408

    Words

  • 161

    Views

  • 0

    Downloads

Trusted by +2 million users,
1000+ happy students everyday
Showing pages 1 to 3 of 7 pages
Physician and PatientBusiness rules are as follows.A diagnosis is given to one or more patients.A patient is given one or more diagnoses.An attending physician sees at least 20 patients.Each diagnosis is given a diagnosis code.A patient can make many appointments with one or more Physicianin the clinic.Doctor can prescribe many diagnosis to many patients.EntitiesPhysicianPatient
DiagnosisEntities RelationPhysician to PatientPatient to PhysicianDiagnosis to PatientPatient to DiagnosisDiagnosis to PhysicianPhysician to DiagnosisOptionality and Plurality constraintsPhysician to PatientOne physician can see many patient.Patient to PhysicianOne patient can see many optional physician.Diagnosis to PatientMany diagnosis to one patient.Patient to DiagnosisOne patient can prescribed to many diagnosis.Diagnosis to PhysicianOne physician can check many diagnosisreport.Physician to DiagnosisPhysician can prescribed many diagnosis to Patient.
Entity Relation Diagram
desklib-logo
You’re reading a preview
Preview Documents

To View Complete Document

Click the button to download
Subscribe to our plans

Download This Document