1. Create an ERD showing the Cardinally and Multiplicity based on the following business rules A student checks books out of the library. They can have multiple books checked out at any given time. A book may be checked out only by a single student. Multiple books are stored in the library, but a book is only stored at a single Tho librarian works at a single library and manages the books. A library has multiple librarians who help check out books with students. A librarian helps a single student at a time with locating a book.

2.

a. Identify the Partial Dependencies Of (if none indicate) b. Identify the Transitive Dependencies (if none indicate) c. Create a dependency diagram showing this table in 2NF d. Create a dependency diagram showing this table in 3NF

3.

14. Use the following Dependency Diagram to answer the followine 15 Given the table below, write out the Relational Schams