In this assignment you will create an Entity Relationship Diagram using

draw.io for the following scenario. When you are done, please click "File $>$ Export As $>$ PNG$",$ and upload the resulting image to this assignment.

Scenario

You are tasked with designing an ERD for a small library management system. This system will help manage books, authors, members, and loans. Read the requirements carefully and create an ERD based on the information provided.

The ERD should include entities, primary keys, foreign keys, and relationships with cardinality and participation.

Scenario: Library Database

Requirements

Books

Each book has a unique ISBN number, a title, a publication year, and a genre.

Each book is written by one author

Authors

Each author has a social security number, a first name, and a last name.

An author can write one or more books. They need to have written at least one book to be in the Library Database

Members

Each library member has a first name, a last name, an email, and a phone number.

Members can borrow multiple books, but a book can only be borrowed by one member at a time.

Loans

A loan is created when a member borrows a book

Each loan has a unique loan ID$,$ the date the book was borrowed, and the due date.

A loan is associated with one member and one book.