LIBRARY SERVICE SYSTEM
Added on 2019-09-23
4 Pages985 Words498 Views
|
|
|
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
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
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents