Design and implement a library system that does the following:
? Takes details of a student/library users: first name, last name, other names, user ID number,
and nationality. The system should be able to add, search and delete a library user from the
system. Deleting in this case should be setting a flag as not active. Note: Student numbers
must be unique.
? Takes details of a library staff: staff id and staff name. Also be able to add, search, and delete
a staff where deleting is setting a flag showing the staff is no longer working in the library.
Note: Staff numbers must be unique.
? Keeps a record of books in the library where a book has the following details: book number,
title, author and subject. Subject in this case refers to discipline where the book belongs to
such as Computer Science, Business, Economics, Chemistry, Biology, History etc. The system
should allow adding a new book, searching for an existing book and updating it, deleting a
book by removing it from the system.
? The system keeps track of books available and how many copies of a certain title are
available. Library members can borrow a book from the system up to a maximum of 3 books
for a member at any time. A library member also returns a book once he or she is finished
with it.
? The system allows reserving a book title if a member wants so as he/she is given priority
when the title is made available.
? There are several reports expected from the system as follows:
- Library users
- Available books in the library
- Reserved books
- Borrowed books
- Staff in the library
? You may or may not design a simple MS Access Database to keep your records or use files
for storage. But you must store your data either way.