Mini Library Book Borrowing System
SECTION A: PROBLEM IDENTIFICATION & ANALYSIS
1. Problem Identification
Many schools and small libraries record book borrowing activities manually in exercise books. This
manual system has several problems such as:
Books borrowed are not recorded accurately.
Misplacement or loss of record books.
Difficulties in tracking who borrowed which book.
Time-consuming to update and search for records manually.
No secure login or authorisation to protect records.
There is a need for a simple computerised system that allows the librarian to record borrowed books
quickly and view all borrowing activities easily.
2. Investigation of the Current System
The current manual borrowing process involves the following:
1. The librarian writes the book title, student name, and date in a record book.
2. When books are returned, the librarian updates the book manually.
3. Borrowed books list is checked by flipping through pages.
4. Records are stored in a single physical book that can be lost or damaged.
This system is slow and unreliable because it is prone to human errors and physical damage.
[Link] of the Existing System
Weaknesses
Records can be lost or torn.
Hard to search for previous borrowed books.
Lack of security—anyone can access the record book.
Writing errors are common.
Takes time to find or update records.
Strengths
No special equipment needed.
Easy for anyone to understand.
No technical training required.
4. Requirements Specification
Hardware Requirements
Computer or laptop with at least:
2GB RAM
2GHz Processor
250GB storage
Keyboard & mouse
Optional: Printer
Software Requirements
Windows Operating System
Visual Basic .NET
Microsoft Access Database (mdb)
.NET Framework
Microsoft Office
. Objectives of the New System
To computerise the recording of borrowed books.
To provide a login system for authorised access.
To store book borrowing information in a database.
To enable fast searching and viewing of borrowed books.
To reduce errors caused by manual writing.
To create a simple, user-friendly interface.
6. Aims of the New System
To replace the manual record book with an electronic system.
To improve accuracy, security, and reliability of borrowing records.
To make it easier for the librarian to track and view borrowed books.
-
SECTION B: SYSTEM DESIGN
1. System Flowchart (Description)
The system follows these steps:
1. User opens the program.
2. User logs in with username and password.
3. If login is correct, the Borrow Book Form opens.
4. User enters Book Title, Student Name, and Borrow Date.
5. User saves the record to the database.
6. User can open the Borrowed List Form to view all borrowed books.
7. User can return to Borrow Book Form.
---
2. Input Design
TextBox for entering Book Title.
TextBox for Student Name.
DateTimePicker for Borrow Date.
TextBox for Login Username.
TextBox for Login Password.
---
3. Output Design
ListView showing:
Book Title
Student Name
Borrow Date
Confirmation messages after saving records.
Error messages for incorrect login.
---
4. Database Design
Table 1: Users
Field Type
Username Short Text
Password Short Text
Table 2: BorrowedBooks
Field Type
ID AutoNumber
BookTitle Short Text
StudentName Short Text
BorrowDate Short Text
---
5. Form Designs
Form 1: Login Form
Username
Password
Login Button
Form 2: Borrow Book Form
Book Title
Student Name
Borrow Date
Save Button
View List Button
Form 3: Borrowed List Form
ListView for all borrowed books
Back Button
---
SECTION C: SYSTEM IMPLEMENTATION
1. Programming Language Used
Visual Basic .NET ([Link])
2. Database Used
Microsoft Access Database ([Link])
3. Coding Techniques Applied
Modular programming
Parameterized SQL queries
Exception handling
Form navigation
ListView population
---
4. Sample Code Snippets
Login Code
cmd = New OleDbCommand("SELECT * FROM Users WHERE Username=@u AND Password=@p", conn)
Insert Borrow Record
cmd = New OleDbCommand("INSERT INTO BorrowedBooks (BookTitle, StudentName, BorrowDate)
VALUES (@b, @s, @d)", conn)
Load Borrowed Books
cmd = New OleDbCommand("SELECT * FROM BorrowedBooks", con
5. System Testing
Test Data Types
Standard Data: Correct username/password, valid book entries.
Abnormal Data: Empty fields, incorrect username/password.
Extreme Data: Very long book titles or names.
Test Results
System logs in correctly with correct details.
System blocks wrong login.
System saves and displays records correctly.
System handles empty fields with error messages.
---
SECTION D: EVALUATION & RECOMMENDATIONS
1. Evaluation of the System
The Mini Library Book Borrowing System successfully meets its objectives:
It stores all borrowed books in a database.
It provides secure login.
It is fast and easy to use.
Records are accurate and well organised.
Form navigation is simple.
2. Strengths
Easy to use
Fast searching and recording
Secure login
Good for small libraries
Reliable database storage
3. Weaknesses
Cannot track book returns (optional future feature)
No printing of reports
Limited to basic borrowing operations
4. Recommendations
Add a Return Book module
Add printing of borrowed books list
Add option to delete or edit records
Add reminders for overdue books
Backup database