Learning Objectives: Students will be able to 1. Create a UML physical model given a fully specified ER diagram Instructions: Using LucidChart (or a modeling tool of your choice) create two UML physical diagrams.

Case Study 2 The image for Case Study 2 is attached on Blackboard as Case_Study_2_ER.pdf" The description below should help you determine appropriate data types. (This is the same as assignment 1, but Specimen was replaced with Animal") Consider an ECOLOGY_TEAM database in which ecology researchers go out into the field to collect data about animals in the field and write research papers about those animals. The data requirements are summarized as follows: Each site is identified by a unique site id number, the latitude and longitude of the northwest corner of the site, and the length and width of the site measured in meters. Each site is divided into one or more regions and each region is numbered (but the region number is not unique across sites). Regions are marked as explored or not explored. A region will contain zero or more animals. Animal details include the genus and species of the animal. An animal can be in multiple regions. Authors of papers are uniquely identified by an e-mail id. First and last names are also recorded. Each paper is assigned a unique identifier by the system and is described by a title, abstract, and the name of the electronic file containing the paper, and the site and animal it references. A paper can also have a status of either in development, submitted, accepted, or rejected. A paper may have multiple authors, but one of the authors is designated as the contact author. . Region Kregion Number (PPK) isExplored Animal genus species It Site siteID (PK) latitude longitude length width HT Paper paperiD (PK) title abstract electronicFilename paperStatus contact regular Author email (PK) firstName lastName