The following incomplete list of business rules describe the relationships between some of the different types of disorders to the human body.
1. Thoracic disorders can be hernias, spine injuries, or neither.
2. Musculoskeletal disorders and gastrointestinal disorders are all disorders, but not all disorders are musculoskeletal or gastrointestinal.
3. Knee disorders are patellar dislocations, knee dislocations, Plica syndrome, or none of these.
4. Structural gastrointestinal disorders can be diverticulosis, colitis, or neither.
5. Gastrointestinal disorders must be either functional gastrointestinal disorders or structural gastrointestinal disorders.
6. Thoracic disorders and knee disorders are musculoskeletal disorders.
7. Constipation and irratible bowel syndrome are functional gastrointestinal disorders.
All relationships described in these rules are specialization-generalization relationships. These rules also reflect the entities and relationships that exist in the real-world.
1. Create a complete list of business rules that are consistent with the incomplete list given above. Try to order the rules logically, either starting at the bottom of the hierarchy working upward, or from the top of the hierarchy working downward. This list should make provision for all entities and relationships given in the above list, and there are many solutions that do so.
1. Musculoskeletal and gastrointestinal is a subtype of disorders and is disjoint
2. Thoracic and knee disorder is a subtype of musculoskeletal disorder
3. Functional gastrointestinal and structural gastrointestinal is a subtype of Gastrointestinal disorder
4. Hernia and spine injuries is a partial overlapping subtype of Thoracic disorder
5. Patellar dislocations, knee dislocations and plica syndrome are the subtype of knee disorders
6. Constipation and irratible bowel syndrome is a subtype of Functional gastrointestinal
7. Diverticulosis and colitis is a partial overlapping subtype of structural gastrointestinal