CSE5331: Homework #2

In a hospital, the following relationships among different entities can be identified: Each doctor can treat many patients and each patient can only be treated by one doctor; each patient may have one disease and many patients may suffer from the same disease; each disease may be cured by different drugs and each drug can be used for different diseases; some diseases are epidemic and some are not; some patients are suffering epidemic diseases and some are not.

• Design an EER schema for this application. Add appropriate attributes for each entity.
• Use O2 class declarations to model your EER schema. Do not use classes to capture many-to-many relationships; instead, use sets of references or sets of tuples.