Ask a question to Desklib · AI bot


Physician and Patient.

Added on -2019-09-16

| 7 pages
| 408 words

Trusted by 2+ million users,
1000+ happy students everyday

Physician and Patient Business 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 Physician in the clinic.Doctor can prescribe many diagnosis to many patients. Entities Physician Patient
DiagnosisEntities Relation Physician to Patient Patient to Physician Diagnosis to Patient Patient to Diagnosis Diagnosis to Physician Physician to DiagnosisOptionality and Plurality constraints Physician to Patient One physician can see many patient. Patient to Physician One patient can see many optional physician. Diagnosis to Patient Many diagnosis to one patient. Patient to Diagnosis One patient can prescribed to many diagnosis. Diagnosis to Physician One physician can check many diagnosis report. Physician to Diagnosis Physician can prescribed many diagnosis to Patient.
Entity Relation Diagram

Found this document preview useful?

You are reading a preview
Upload your documents to download
Become a Desklib member to get accesss

Students who viewed this