1. Create a Crow's Foot Entity Relationship Diagram (ERD) for the following business rules. Please exclude attributes. (MS Visio Crow's Foot Database Notation Template) a. One publisher publishes many books and must publish at least one book. b. Each book must be published by one publisher. c. A publisher submits many (book) contracts and must be submitted at least one contract d. Each (book) contract must be submitted by one publisher. e. One author signs many contracts and must sign at least one contract. f. Each contract must be signed by one author. g. One author writes many books and must write at least one book. h. Each book must be written by one author. i. One student may purchase many books or may not purchase any book. j. One book may be purchased by one student or may not be purchased by any student k. One book belongs to more than one book category and must belong to at least one category 1. One category may include many books. 1. Create a Crow's Foot Entity Relationship Diagram (ERD) for the following business rules. Please exclude attributes. (MS Visio Crow's Foot Database Notation Template) a. One publisher publishes many books and must publish at least one book. b. Each book must be published by one publisher. c. A publisher submits many (book) contracts and must be submitted at least one contract d. Each (book) contract must be submitted by one publisher. e. One author signs many contracts and must sign at least one contract. f. Each contract must be signed by one author. g. One author writes many books and must write at least one book. h. Each book must be written by one author. i. One student may purchase many books or may not purchase any book. j. One book may be purchased by one student or may not be purchased by any student k. One book belongs to more than one book category and must belong to at least one category 1. One category may include many books