Answer to Problem 2.1

Here's my assumptions for this situation:

  • It would seem that at any particular time a patient can only have one primary care physician and that any physician can have many patients (M:1).
  • One physician can perform many operations and one operation can be performed by many physicians (M:M).
  • One doctor can have specialties in many diseases and one disease can be the specialty of many doctors (M:M).
  • One needle can be injected into one patient and one patient can have many needles injected into him/her (M:1).

Return to details of ER modeling.

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-NonCommercial-ShareAlike 3.0 License