Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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,

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedIimage text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advances In Spatial And Temporal Databases 10th International Symposium Sstd 2007 Boston Ma Usa July 2007 Proceedings Lncs 4605

Authors: Dimitris Papadias ,Donghui Zhang ,George Kollios

2007th Edition

3540735399, 978-3540735397

More Books

Students also viewed these Databases questions