Question: I For this assignment we are going to design a system to Manage loans fro public library For this we will need the following entities,

I For this assignment we are going to design a system toManage loans fro public library For this we will need the followingentities, plus collections for each of the entities: Patrons, Books and LoansThe data for a Book will contain at least the following: AuthorTitle ISBN Number Library ID number Cost Current Status (In, Out, Repair,Lost) You may add other data needed for your implementation as wellas you will need accessor and mutator functions for the data. TheIdata for a Patron will contain at least: Name (e.g. Fred Smith)

For this assignment we are going to design a system to Manage loans fro public library For this we will need the following entities, plus collections for each of the entities: Patrons, Books and Loans The data for a Book will contain at least the following: Author Title ISBN Number Library ID number Cost Current Status (In, Out, Repair, Lost) You may add other data needed for your implementation as well as you will need accessor and mutator functions for the data. The data for a Patron will contain at least: Name (e.g. Fred Smith) ID number (6 digits e.g. 123456) Fine Balance Current \# of books out You may add other data needed for your implementation as well as you will need accessor and mutator functions for the data. The data for a Loan (The transaction entity) will contain at least the following: Loan ID Book ID Patron ID Due Date and Time Current Status (overdue, normal) You may add other data needed for your implementation as well as you will need accessor and mutator functions for the data. For the collections of each of the Patrons and Books Classes identified above Check Out a book (update book and patron info as well as add a loan) Check in a book (check for fines and update patron and book info and delete loan) List all overdue List all books for a particular patron Update loan status based on system clock Re-Check a book Edit a loan Report lost (update book and charge patron book cost as well) Other methods you may identify You will need to verify the following 1. Before borrowing a book, make sure Patron has no overdue books and that total books out will be

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!