Hi,Good day.I've already posted this question but didnot receive good answer according the requirements of the question. specially regarding updating list of copy,loan-book updating ,having at leat 6 entity and those tranaction and relationships betwwen them with PK AND FK. I would appreciate if you good prepare me the appropriate answer to the following question:

Create an ER-Model (conceptual and physical)Depending on the following requirements in each numbers.

1-In a library management system the transactions done every day are as follows:Record new books with the following important information.

Author information;

Book information;

List of copy; and

Borrowers

2.When a student borrowed book, the number of copies in the records also update which deduct from the total number of copies. Students records are also saved in the database.

3.Whenever a student borrowed a book the librarian set a loan date, which helps the librarian monitor the returned and unreturned book.

From the given scenario above, create an ER-model with at least compose of six (6) Entities. In each entity there should be Primary Key assign and should be referenced to another table. Add attribute in each entities as well the relationship of one entity to another entity.