Return to Question

###Business scenario description###

###Entity Type Definitions###

###My considerations###

• The specific issue I can not seem to wrap my head around is the existence of multiple relationships between the entity types.

First of all, I do not even know what kind of cardinalities to put on regarding the relationship between Order and Treatment.

• Another issue for me is the multiple relationships between Patient, Diagnosis and Physician. Also, the same issue with Physician, Patient, and Treament.

Are these perhaps suppose to be ternary degree relationships, and (or) contain weak entity types to make this more understandable? Like Order and Treatment, or Treatment and Diagnosis I could see one depending on another as a Treatment in my mind would depend on the Diagnosis (correct me if I am wrong).

Business scenario description

Entity Type Definitions

My considerations

• The specific issue I can not seem to wrap my head around is the existence of multiple relationships between the entity types.

  First of all, I do not even know what kind of cardinalities to put on regarding the relationship between Order and Treatment.

• Another issue for me is the multiple relationships between Patient, Diagnosis and Physician. Also, the same issue with Physician, Patient, and Treament.

  Are these perhaps suppose to be ternary degree relationships, and (or) contain weak entity types to make this more understandable? Like Order and Treatment, or Treatment and Diagnosis I could see one depending on another as a Treatment in my mind would depend on the Diagnosis (correct me if I am wrong).