logo

Library Service System for University | Desklib

4 Pages985 Words498 Views
   

Added on  2019-09-23

About This Document

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.

Library Service System for University | Desklib

   Added on 2019-09-23

ShareRelated Documents
AAPP008-4-2 Visual Basic.NET Page 1 of 4AssignmentTitleLIBRARY SERVICE SYSTEMSection A:Program SpecificationThis project requires your group to develop a Library Service System for a university. Thesystem is specifically designed for librarians. Once the system is opened, the user must entertheir unique ID number and password. Upon login, the system should display the user’s actualname 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.BorrowingAll staffs and students of the university are entitled to borrow all library items byusing their ID number. The loan duration for all materials is 2 weeks or 14 days fromthe borrowing date.b.RenewalThe borrower may renew their book to extend the loan duration, provided it is doneon or before the expiry date. The system should check whether the item is overduefirst before making any changes to the loan item.c.FinesAn item will become overdue if it is not returned or renewed on or before the expirydate. In case a borrower isn’t able to return the item on time, the system willautomatically compute for the corresponding fine. The current fine rates for latereturn of items are RM1 per day. The system should compare the current date withthe loan duration in the database in order to calculate the fine amount.d.ReportThe system should produce a status report of all borrowed books based on the currentdate which includes the borrower id, the borrower’s name, book id, book’s title, dateof borrowed, and the return date. Hint: This could be achieved using the Report toolin Visual Studio by connecting the report to a dataset.__________________________________________________________________________________________Diploma Level 2Asia Pacific Institute of Information Technology 2016/12
Library Service System for University | Desklib_1
AAPP008-4-2 Visual Basic.NET Page 2 of 4REQUIRED DATABASE TABLESMemberDescriptionID NumberMember identification number, TP number or staff number.Member NameMember’s name.Contact NumberMember’s mobile number.Email addressMember’s e-mail address.LibrarianDescriptionLibrarian IDLibrarian identification number, automatically generated by the system in sequence.Librarian nameLibrarian’s name.Librarian passwordPassword for logging into the system.BookDescriptionISBNA unique numeric commercial book identifier.AuthorsNames of authors.EditionEdition of the book.PublisherPublisher name.YearPublished year.LoanDescriptionLoan IDA unique loan number for each transaction.Expiry DateThe expiry date.Return DateThe return date.Member IDAs foreign key.ISBNAs foreign key.__________________________________________________________________________________________Diploma Level 2Asia Pacific Institute of Information Technology 2016/12
Library Service System for University | Desklib_2

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Information Management System Analysis
|24
|2172
|41

The Uni library System Assignment PDF
|26
|3070
|47

Software Engineering for Library Management System
|13
|1520
|478

Assignment On The Pay Fine
|13
|1115
|59

Library Management System for Desklib
|42
|1471
|288

Library System - Assignment Sample
|12
|905
|30