Ask a question to Desklib · AI bot
Physician and Patient.
Added on -2019-09-16
| 7 pages
| 408 words
| 245 views
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
or
Become a Desklib member to get accesss
Paid Plans
Free Plan
Single Unlock
Monthly Plan
Yearly Plan