- 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.
-
Return list of all overdue books for that patron.
-
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.