The library of the University of Happiness is creating a database that will store information about users, books, and circulation. It contains the following:

$4$ tables for the database: USERS, BOOK$\_$COPY, BOOK, and CHECKOUT. $($Since a book may have multiple copies that may be purchased by the library at different times, it is better to have a BOOK$\_$COPY table to avoid unnecessary data redundancy.$)$

The data in the tables are as follows:

USER table records a patron$$s ID$,$ name, address, phone number, email address, classification, and status.

BOOK table contains author, title, publication date, subject, language, genre, format, and a unique identifier $($It can be the ISBN of the book$)$ for each book.

BOOK$\_$COPY table records a unique identifier for each copy of a book, the date of purchase, and the identifier of the book from the BOOK table.

CHECKOUT table records a unique checkout identifier, the date of check$-$out, patron$$s ID$,$ the identifier of the book copy from the BOOK$\_$COPY table, and the due date.

Create an ERD $($Entity Relational Diagram$)$ for the University of Happiness Library database using Crow$$s Foot notation $-$ as demonstrated$/$explained in class.

The ERD should include all the entities, fields, keys, relationships, and connectivity where applicable.

Create a data dictionary in Word or Excel for the University of Happiness Library ERD you just created.The data dictionary should contain all the attribute names and characteristics for each table in the system.

Please create an ERD Diagram using Crow's foot notation to show relationship between tables. Ater creating ERD diagram use that to create a data dictionary for the database. No code needed.