Question

1. The following set of brief scenarios describes the relationships between various entity classes. Draw the entity classes (only show entity name - no attributes or identifiers) and the relationship making sure to add notation (use any standard notation) that shows reasonable minimum and maximum cardinalities given the implied scenario. All scenarios will only have one relationship. The one relationship may be between a maximum of two entity classes (binary) or between an entity class and itself (recursive). If you make any assumptions beyond what is stated be sure to note that in your answer. ). A University is using a database to keep track of courses being offered as well as the prerequisite courses that nust be taken prior to taking a specific course. Every course in the database may have zero to many prerequisite ourses and every course may be prerequisites for zero to many offered courses.

Answer 1

Cources Prerequisite

Note: There is recursive relationship.