Design a database for a library based on

-Specifying the entities, attributes and their key attributes

-specifying the relationships between entities, participation of each relationship

II- ER diagram A database for libraries contains information about books, authors of books, the subject of books and other information. Draw and ER diagram that describes the library database and make sure to write any assumptions you make and any constrains you think should hold. Make sure that your assumptions are logical. Each book is identified by a publishing number and has a titlel| Every author has a name, an SSN and a contact phone number and each author has at least one book that he wrotel All books are indexed by subjects where each subject has a subject title and a subject number that identifies the subjectl Every[library/carries a certain number of books and each library has a name and a location (city)