Question: Write a Java program that uses a library database of books and patron data, as described in Exercise R24.2. Patrons should be able to
Write a Java program that uses a library database of books and patron data, as described in Exercise • R24.2. Patrons should be able to check out and return books. Supply commands to print the books that a patron has checked out and to find who has checked out a particular book. Create and populate Patron and Book tables before running the program.
Data from exercise R24.2
Design a set of database tables to store library books and patrons. A book has an ISBN (International Standard Book Number), an author, and a title. The library may have multiple copies of each book, each with a different book ID. A patron has a name, a unique ID, and an address. A book may be checked out by at most one patron, but one patron can check out multiple books.
Step by Step Solution
3.37 Rating (153 Votes )
There are 3 Steps involved in it
Assuming that you have your database already set up with tables for Book and Patron and you have your library database ready for use heres a simple ex... View full answer
Get step-by-step solutions from verified subject matter experts
