Design and implement a library system

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.

Reference no: EM1343491

Questions Cloud

Calculate minimum costs, times, and cost schedules : Calculate minimum costs, times, and cost schedules - What is the minimum cost to crash the project one week and What activity will be crashed

Limitation of research and project : Many will argue that it is considered a good practice to acknowledge the limitation of your research and project

How did the virginia plan : How did the Virginia Plan, the New Jersey Plan, the Great Compromise, and the Three-Fifths Compromise lead our current form of Congress?

Case of a member of a manager-managed llc : Case of a member of a manager-managed LLC - Eric is a member of a manager-managed LLC but is not a manager. This LLC invests in real estate and manages it as rental property in a college town.

Design and implement a library system : 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.

Manager-managed llc : Lynda will be allowed to participate, but is not entitled to any compensation

Cost of production report using fifo : Prepare a cost of production report for July using the FIFO method of the process costing - Cost of production report using FIFO

Benefits of dealing with a national labor market : What are some benefits of dealing with a national labor market and what are some risks? Should a business ever avoid dealing with a national labor market? What would be an example?

Limiting the significant growth of a sole proprietorship : Short Answer and Short Problems, Briefly discuss the most important factors limiting the significant growth of a sole proprietorship or partnership?

User Account

All Pages