logo

Physician and Patient.

7 Pages408 Words245 Views
   

Added on  2019-09-16

Physician and Patient.

   Added on 2019-09-16

ShareRelated Documents
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
Physician and Patient._1
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.
Physician and Patient._2
Entity Relation Diagram
Physician and Patient._3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
The two parts in this assignment will contribute equally to your
|3
|1619
|423

Assignment on Business Rule pdf
|7
|2289
|1561

Database Concepts Assignment
|3
|834
|260

Logical Data Modeling through Physical Design
|16
|3139
|11