Question
Design a set of database tables to store library books , patrons, and ckeckoutbooks. A book has a CallNo, an author, and a title. The
Design a set of database tables to store library books , patrons, and ckeckoutbooks. A book has a CallNo, 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 SSN and Name. Checkout book has SSN and CallNO . A book may be checked out by at most one patron, but one patron can check out multiple books.
Write a VISUAL BASIC program that creates a library database of books ,patron and ckekoutbooks data as described above. Patrons should be able to check out and return books. Supply commands to print the books that a patron has checked out , return a book, list library user with the book they checked out and EXIT. You may create and populate Patron, Book tables, and checkoutbooks table before running the program.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started