1. Return the due date of a book for a patron.

• patron id number, copy id number, book title, due date

select books where patron id = patron id AND check in is 0, JOIN copies on copies id. JOIN books on books id.

2. Return list of all overdue books for that patron.

3. Return list of all overdue books for that patron that have not been checked in.

• checkin

make a method from copies that can get the titles of the book copies join patrons to checkouts to copies.