Design and implement a library system that does the

Reference no: EM13363454

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.

Reference no: EM13363454

Questions Cloud

Calculate minimum costs times and cost schedulesconsider : calculate minimum costs times and cost schedulesconsider the following table of crash times and costs for the above

Limitation of researchprojectmany will argue that it is : limitation of researchprojectmany will argue that it is considered a good practice to acknowledge the limitation of

1how did the virginia plan the new jersey plan the great : 1.how did the virginia plan the new jersey plan the great compromise and the three-fifths compromise lead our current

Case of a member of a manager-managed llceric is a member : case of a member of a manager-managed llceric is a member of a manager-managed llc but is not a manager. this llc

Design and implement a library system that does the : design and implement a library system that does the following ? takes details of a studentlibrary users first name last

Manager-managed llclynda is a member of a manager-managed : manager-managed llclynda is a member of a manager-managed llc but is not a manager. however lynda has considerable

Cost of production report using fifoequivalent : cost of production report using fifoequivalent productionbangor products manufactures electronics language translators.

Expatriate manager1 would you recommend hiring a local : expatriate manager1. would you recommend hiring a local manager over an expatriate manager? why? does the phase of the

Short answer and short problems1nbspnbspnbspnbspnbsp : short answer and short problems1.nbspnbspnbspnbspnbsp briefly discuss the most important factors limiting the

User Account

All Pages