Please help reading the following instructions

Learning Objectives: Students will be able to 1. Create a UML physical model given a fully specified ER diagram

Both Case Study Images that you need to answer case 1 & case 2 is attached below

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. One for the first case study and a different one for the second. Be sure to include your name and today's date on the diagrams, so I can keep track once I've downloaded them. Case Study 1 The image for Case Study 1 is attached on Blackboard as Case Study_1_ER.pdf' The description below should help you determine appropriate data types. (This is the same as Assignment #1, except with the added note) Consider an INSTRUMENTS database in which a band instructor keeps track of students who are renting instruments. The data requirements are summarized as follows: Students are identified by a unique student number, name (which is their first, middle, and last name), address, city, state, and zip code. Each instrument is identified by a unique inventory number, instrument name, if it includes a case or not, and daily rental cost. Each current rental is defined by a transaction that includes the student, the instrument rented, the rental date, the due date, the number of days rented (which is calculated, rather than stored), and the cost of the rental (which is calculated, rather than stored). (Note: A student can rent more than one instrument at a time) When an instrument is returned, the database will store the condition of the instrument (a rating from 1- 10), the student who returned the instrument, and the date it was returned in a separate table. . Student CurrentRental studentNumber (PK) rentalDate HO name first middle last due Date 7 daysRented Instrument inventory Number (PK) name hasCase dailyRentalCost address city state zipcode Rental History condition returnDate 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. . Animal Site sitelD (PK) latitude Region Kregion Number (PPK) isExplored genus species longitude length width Paper paperID (PK) title abstract electronicFilename paperStatus contact regular Author email (PK) firstName lastName