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 classes fonly show entity name - no attributes or identifiers) and the relationship, making sure to add notation (use crow's foot notation) that shows reasonable minimum and maximum cardinalities given the Implied scenario. All songs will only have one relationship. The one relationship may be between medium of two-entity classes thinery 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. 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 4 Sections a. (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 overveea 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. 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 promotion sued on the types of pets that they have. Each pet type (e.g., dog, cat) may be associated with tero or more specific breas, 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 oversea 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. c. (9 points) The College of Business PhD Subcommittee is currently working to revise the "college core courses that all PhD. students must take, regardless of their concentration. As part of that effort, subcommittee members must pay careful attention to course sequencing, which includes specifying course prerequisites that ensure adequate preparation before taking higher level courses, while still allowing students adequate scheduling flexibility. All suggested changes must be approved by the university before they can be incorporated into the next course catalog. The catalog entry for a particular course may list zero or more other courses as prerequisites. Further, a course may be designated by zero or more other courses as being a prerequisite itself An example dog breed would be Betickoonhound An example cat breed would be Cornish Rex. "Unknown" in combinati with the pets weight category defeated ently tor dogs and cats is considered a valid breed for dogs and cats. Other type pers are en breed destinations
