CS 346 - Database Management Systems Summer II 2018 Homework 1 1. Using the business rules listed below; create a Crow's Foot ERD that captures these rules. .A publisher can publish many books and each book is published by one publisher. .Any book can have many book copies and each book copy is related to one and only one . A library branch may have one or more book copy and each book copy is located in one and * A borrower may borrow one or more book copy and each book copy may be borrowed by An author can write one or more books and each book can have one or more authors. book only one library branch one and only one borrower 2. Study the ERD given below and write the business rules that are reflected in the diagram. HOTEL EmploysHote EMP NUM has Hatel ddress Htel Phone -Type Max Guests Auailablity Included in GUEST Makes Guest o Check In Check Out BILL Res Num