We are asked to create a database for the library of the University of Happiness. The database 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 patrons ID, name, address, phone number, and email address.
• BOOK table contains information such as author, title, publication date, subject, language, 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 the date of check-out, patrons ID, the identifier of the book copy from the BOOK_COPY table, and the due date.