Reference no: EM1343491

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.