Practicum #1: Design (100 points total) Question 1. (27 points total) The following set of brief scenarios describes the relationships between various entity classes. Draw the entity (only show entity name - no attributes or identifiers) and the relationship, making sure to add rotation (use crow's foot notation) that shows reasonable minimum and maximum cardinalities given the implied scenario. Allano 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) you make any assumptions beyond what is stated, be sure to note that in your answer. Example: Students can take no sections or may take any number of sections. Each section has anywhere from zero to an unlimited number of students. Example Answer: Students of sections (9 points) The Amazon mobile app allows customers to set up pet profiles for all of their pets, whether they be goldfish, hamsters, dogs, or horses. This allows Amazon to offer its customers targeted promotions based on the types of pets that they have. Each pet type (e.g., dog, cat) may be associated with zero or more specific breeds, and each breed stored in the Amazon database will correspond to exactly one pet type! b. (9 points) A hospital stores data about its nurses and their relationships to nursing stations in the hospital Although nurses are related to nursing stations in several ways, we are interested here in determining which nurse is designated as the primary administrator of specific nursing stations. By policy, a nurse can only oversee a maximum of one nursing station. Each nursing station, likewise, can only have one primary administrator. All nursing stations must also have at least one primary administrator. Of course, many of the nurses in the database are not administrators at all