Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Project B: Library Information System Overall description: Your team is employed by a university for the implementation of a computer system for the library and

Project B: Library Information System
Overall description:
Your team is employed by a university for the implementation of a computer system for the
library and its borrowing facilities.
Customer specifications:
The implemented system should be able to handle the basic operations of a university library,
including the following features:
o It must be able to store the set of books including their author(s), title, ISBN, subject,
loan type (normal, short loan, no-take-out), shelf mark, loan status, number of copies,
etc. Also, it should provide options for altering the details of a book, mark it as
lost/damaged/ordered, etc.
o Registration of a new library user with varying privileges (e.g., maximum number of
books), which can be altered for any existing user at any time.
o Search for a particular book and allocate a book to a specific borrower for a specific
time period. Also, implement returns and renewals.
o Provide library statistics about the number of books and borrowers and if possible
their different types.
o Provide borrower statistics about the number of books and charges incurred to a
particular account. Implement payment and account blocking.

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_2

Step: 3

blur-text-image_3

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

Learning MySQL Get A Handle On Your Data

Authors: Seyed M M Tahaghoghi

1st Edition

0596529465, 9780596529468

More Books

Students also viewed these Databases questions