LIBRARY SERVICE SYSTEM

The assignment requires a group of not more than three members to develop a Library Service System for a university using Visual Basic .NET. The system should have functionalities such as borrowing, renewal, fines, and report generation. It also includes requirements for database tables, submission, and presentation, with a total weighting of 100% for the group assessment and 30% for individual components.

AAPP008-4-2 Visual Basic.NET Page 1 of 4
Assignment
Title
LIBRARY SERVICE SYSTEM
Section A: Program Specification
This project requires your group to develop a Library Service System for a university. The
system is specifically designed for librarians. Once the system is opened, the user must enter
their unique ID number and password. Upon login, the system should display the user’s actual
name on the system’s user interface. Librarians are allowed to make transaction for borrowing,
renewing or returning book. In addition, they should have access to the loan details report.
The system must have the following functionalities:
a. Borrowing
All staffs and students of the university are entitled to borrow all library items by
using their ID number. The loan duration for all materials is 2 weeks or 14 days from
the borrowing date.
b. Renewal
The borrower may renew their book to extend the loan duration, provided it is done
on or before the expiry date. The system should check whether the item is overdue
first before making any changes to the loan item.
c. Fines
An item will become overdue if it is not returned or renewed on or before the expiry
date. In case a borrower isn’t able to return the item on time, the system will
automatically compute for the corresponding fine. The current fine rates for late
return of items are RM1 per day. The system should compare the current date with
the loan duration in the database in order to calculate the fine amount.
d. Report
The system should produce a status report of all borrowed books based on the current
date which includes the borrower id, the borrower’s name, book id, book’s title, date
of borrowed, and the return date. Hint: This could be achieved using the Report tool
in Visual Studio by connecting the report to a dataset.
__________________________________________________________________________________________
Diploma Level 2 Asia Pacific Institute of Information Technology 2016/12

AAPP008-4-2 Visual Basic.NET Page 2 of 4
REQUIRED DATABASE TABLES
Member Description
ID Number Member identification number, TP number or staff number.
Member Name Member’s name.
Contact Number Member’s mobile number.
Email address Member’s e-mail address.
Librarian Description
Librarian ID Librarian identification number, automatically generated by
the system in sequence.
Librarian name Librarian’s name.
Librarian password Password for logging into the system.
Book Description
ISBN A unique numeric commercial book identifier.
Authors Names of authors.
Edition Edition of the book.
Publisher Publisher name.
Year Published year.
Loan Description
Loan ID A unique loan number for each transaction.
Expiry Date The expiry date.
Return Date The return date.
Member ID As foreign key.
ISBN As foreign key.
__________________________________________________________________________________________
Diploma Level 2 Asia Pacific Institute of Information Technology 2016/12

AAPP008-4-2 Visual Basic.NET Page 3 of 4
Section B: Deliverables
This is a group assignment and each group should consist of NOT MORE THAN THREE (3)
persons. The program submitted should compile and be executed without errors. Besides,
validation should be done for each entry from the users in order to avoid logical errors.
SUBMISSION REQUIREMENTS
You or your group is required to submit the following for your documentation:
1. A softcopy of the program coded in VB.NET – submitted in a CD.
2. A documentation of the system, that incorporates basic documentation standards such as
header and footer, page numbering, and which includes:
 Assignment cover page
 Table of contents
 Introduction
o This should include the task, the scope of the new system, and the objectives for
the new system.
 Screen designs
o This section includes the sketch design of the Graphical User Interface, indicating
the layout and the components to be used for the interface (forms and report
structures).
 Sample outputs
o This section includes the actual screen when the program is executed.
o Explain any additional features which have been incorporated in the solution.
 User manual
o Produce a detailed user manual of at least 10-15 pages on using the system that
you or your group has developed. The manual must include step by step
instructions to perform a specific task in the system which includes screen shots
to assist users in using the system.
 Critical Assessment
o Identify the strengths and the weakness that you or your group has found in the
new system. If there any weaknesses, provide recommendation(s) on how the
system might be improved in the future.
 References
o The references list should use the Harvard Referencing format. Reference is
work/code you have used them directly from sources such as forums, tutorials and
websites for completing your project.
The documentation should be comb-bound with the CD attached.
__________________________________________________________________________________________
Diploma Level 2 Asia Pacific Institute of Information Technology 2016/12

AAPP008-4-2 Visual Basic.NET Page 4 of 4
Submission deadline: February 20th 2017, 5:00 PM
PRESENTATION
Each group is to prepare a 10-15 minutes presentation to demonstrate the system to the lecturer.
The presentation will be graded based on the ability to demonstrate the working of the system
and the ability to answer questions asked related to the program developed which may include
code modification or explaining the code used in the system during the presentation. Failure to
attend the presentation will be subjected to Extenuating Circumstances (EC) mitigation and
possibly a zero mark for the system implementation (Group Component – Coding and
Implementation, Individual Components – Program Solution and Presentation).
Section C: Component Weighting
Group Assessment
Coding and Implementation : 50%
Documentation, Storyboard and Design : 20%
Individual Assessment
Program solution : 15%
Presentation : 15%
Plagiarism is a serious offence and will be dealt with according to APIIT and Staffordshire
University regulations on plagiarism.
__________________________________________________________________________________________
Diploma Level 2 Asia Pacific Institute of Information Technology 2016/12