You have been asked to design a database for a Library. The model is to be understood as follows:

Entities:

Each book has an id which should be unique for every book, a title, ISBN number, publication

year and genre.

Library has members, every library member has a unique id$,$ name, address and phone

number.

The books are written by authors. Each author has a unique id$,$ name and birth date.

Books are published by publishers. A publisher has a unique id$,$ name, address, and a contact

email.

Relationships:

Library members can borrow different books, and books can be borrowed by different people.

An author can write a lot of books but a book should be written by just one author.

A publisher can publish more than one book, but a book belongs to one publisher.

$**$ Construct your ER diagram for the given scenario. Be sure to mark the multiplicity of each

relationship $(1-1,1-$many, many$-$many, any weak entities, etc$)$ of the diagram. Decide the key

attributes and state all assumptions you make.

$**$ You can send your solution in jpeg, png or pdf format.