A library has a collection of books each of which is identified by an ISBN $($International Standard Book Number$)$ and a copy number. The title of a book, its first author, its publisher, and its year of publication need to be kept track of$.$ The books may be borrowed by borrowers who are identified by their social security numbers $($SSN$).$ The name and address of each borrower must be kept track of$.$ For each book that is currently loaned out, the borrower's SSN$,$ the date charged out, and the date due need to be stored.

The library staff will be using the database application to get answers to the following types of queries:

Query $1$: Give ISBN's for books currently loaned out.

Query $2$: Give ISBN and Title for books currently loaned out.

Query $3$: List ISBN and Title of books that we carry at least $5$ copies of$.$

Query $4.$ How many books by Jimmy Carter $($as first author$)$ are checked out?

Query $5.$ For each year, list the number of titles published in that year that the library carries.

Query $6$: List borrowers with overdue books and number of days overdue.

What is the best ERD to satisfy the information requirements above?

Paste your ERDPlus Image Diagram as your post for grading.