CS 346 - Database Management Systems Summer II 2018 Homework 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 An author can write one or more books and each book can have one or more authors book. only one library branch A borrower may borrow one or more book copy and each book copy may be borrowed by one and only one borrower 2. Study the ERD given below and write the business rules that are reflected in the diagram EMP NUM Employs has Hetel ID Reom Type Hote Phone Included in Makes Res NuM Room Num GuntJD Check i Check-Out Phone Generates Invoice Num Toral Charge