You have been deputized by the President of Catskill University to develop a library database. The library database must be able to store and track data regarding books in the library, the authors of those books, and the publishers of those books. Students at Catskill University can borrow books from the library - their data too need to be stored in the database The operating environment of the library is as follows: A book can be authored at the most by many authors and at the least by one author. An author at the most can author many books and at the least can author one book. - A book can at the most be published by one publisher and at the least be published by one publisher (meaning, a book is published by exactly one publisher). A publisher can publish at the most many books and at the least one book. A student at the most can borrow many books and at the least zero books (this is because some students never borrow books). A book at the most is borrowed by one student and at the least by one student (meaning, a book is borrowed by exactly one student). Based on your analysis, you have identified the following entities for your database: BOOK, AUTHOR, PUBLISHER, STUDENT Develop an E-R model using the IE Crow's foot diagram for Catskill University library. The E-R model must depict the four entities identified above, and at least four attributes per entity including a surrogate primary key. In the case of intersection/bridge table(s), you need show only three attributes per entity including a surrogate primary key (the other two can be foreign keys). You can use your general knowledge to come with suitable attributes (for example, the BOOK entity could have the surrogate primary key Bookid, the other three attributes being BookName, NoOfPages, and ISBNNumber). It should depict the minimum and maximum cardinality relationships between the entities (50 points). The maximum cardinality relationships should be implemented using appropriately positioned foreign keys (50 points). You can develop the E-R model using draw.io and upload it to Canvas as a pdf file (see Drawing an ER diagram using drawio under Week 10 in Canvas) OR draw a neat sketch of your E-R model, scan or take a photo of it, and upload it to Canvas. The diagram should be similar to what is shown here (see Week 11 notes)