Design a database for a "Library". Based on the following description. Draw the

corresponding ER diagram by:

Specifying the entities, their attributes, and their key attributes

Specifying the relationships between entities, participation, and multiplicities of

each relationship.

A library database contains information about books, authors of books, the subject of books and

other information. Draw an 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 your

assumptions are logical$.$

Each book is identified by a publishing number and has a title. Every author has a name, an SSN

and a contact phone number and each author has at least one book that he wrote. All books are

indexed by subjects where each subject has a subject title and subject number that identifies the

subject. Every library carries a certain number of books, and each library has a name and a

location $($City$).$