Library Management System

STUDENT DATABASE MANAGEMENT SYSTEM

ABSTRACT • A library management is a project that manages and stores books information electronically according to students needs. • The system helps both students and library manager to keep a constant track of all the books available in the library. • It allows both the admin and the student to search for the desired book. • It becomes necessary for colleges to keep a continuous check on the books issued and returned and even calculate fine.  This task if carried out manually will be tedious and includes chances of mistakes.  These errors are avoided by allowing the system to keep track of information such as issue date, last date to return the book and even fine information and thus there is no need to keep manual track of this information which thereby avoids chances of mistakes.

STACKHOLDERS • Library manager • student

SYSTEM STUDY • Existing system drawbacks • Proposed system advantages

EXISTING SYSTEM • this project of “library management” of gives us the complete information about the library. • We can enter the record of new books and retrieve the details of books available in the library. • We can issue the books to the students and maintain their records and can also check how many books are issued and stock available in the library. • In this project we can maintain the late fine of students who returns the issued books after the due date. • Throughout the project the focus has been on presenting information and comments in an easy and intelligible manner.

EXISTING SYSTEM DRAWBACKS • Library management system have very large library that will difficult to update. • If the software is corrupted ,whole data will be collapsed.

PROPOSED SYSTEM • To overcome the drawbacks of the existing system. • Proposed system is an automated Library Management System. • Through our software user can add books, search books, renewal, update information, edit information, and return books in quick time.

PROPOSED SYSTEM ADVANTAGES • User friendly interface • Fast access to database • Less error • More Storage Capacity • Search facility • Look and Feel Environment • Quick transaction

PROJECT DESCRIPTION • A library management system enhances the efficiency of the librarians and library users. • A library management system reduces the cost of management. • The system eliminates the need to employ many workers and keep different manual files thereby reducing the cost.

MODULE DESCRIPTION • • • • • • •

admin Search option Borrow books Report module Calculate Fine Add and Update Books User

MODULE DESCRIPTION CONT.. •

• •

• • • •

admin: In this module registration of the people who arrive to the library . The receptionist has the authority to enter the name, address and contact number of the people who visit the library along with the name of the book they want to read. Search option: available books in the library can be searched through the module. Borrow books: a person can also borrow the book for particular days . All the information will entered in the system. If the person doesn't return the book before due date ,a fine will be added and the information will be sent to that particular person about the fine. reports: in this module generate the report for the books details. Calculate Fine- The student can view the issue and expiry date for the book issued and can even calculate fine. Add and Update Books: The admin can add books to the system by entering the details of the books and can even update the details. User : Students have to register themselves into the system to create an account. After registering successfully, they can then login into the system by entering 10 digit mobile number.

REQUIREMNET PHASE • • • • •

software requirements hardware requirements Testing tools Development tools Data collection

Software requirements operating system : windows 7 front end : VB.NET back end : SQL server

Hardware requirements Processor Hard Disk RAM Monitor Keyboard Mouse

: Pentium Dual Core : 80 GB : 1GB RAM : 15 ” VGA Color Monitor : 104 Keys Keyboard : LOGITECH

Testing tools • • • • • • • •

Unit testing Block box testing White box testing Module testing Integration testing Validation testing Output testing Code testing

Unit resting • In this online examination system unit testing check login form. Unit testing focuses verification efforts on the smallest unit of the software design, the module. • Unit testing focuses verification efforts on the smallest unit of the software design, the module. This is also known as “Module Testing”. • The modules are tested separately. • This testing carried out during programming stage itself. In this testing each module is found to be working satisfactorily as regards to the expected output from the module.

Block box testing Black box testing attempts to derive sets of inputs that will fully exercise all the functional requirements of a system. It is not an alternative to white box testing. This type of testing attempts to find errors in the following categories: • incorrect or missing functions, • interface errors, • errors in data structures or external database access, • performance errors and • Initialization and termination errors.

White box testing • Tests are based on coverage of code statements, branches, paths, and conditions. Also, the tests are based on knowledge of the internal logic of an application's code.

Integration testing • In this integration testing the modules are check one by one up to end module. Data can be grossed across an interface; one module can have adverse efforts on another. • Integration testing is systematic testing for construction the program structure while at the same time conducting tests to uncover errors associated with in the interface. • The objective is to take unit tested modules and build a program structure. All the modules are combined and tested as a whole. • Here correction is difficult because the isolation of cause is complicate by the vast expense of the entire program. • Thus in the integration testing stop, all the errors uncovered are corrected for the text testing steps.

Output testing •

•

•

•

In output testing each test has a different purpose all the work should verify that all the system elements have been properly integrated and perform allocated functions. No system could be useful if it does not produce the required output. Here, output testing is done by checking whether the data being updated through database is coming in the correct portion and position of the website template. User Acceptance Testing: User acceptance of a system is the key factor of the success of any system. The system under study is tested for the user acceptance by constantly keeping in touch with the prospective system users at the time of developing and making changes wherever required. Test Data: Taking various kinds of test data does the above testing. Preparation of test data plays a vital role in the system testing after preparing the test data the system under study is tested using the test data. While testing the system by using the test data errors are again uncovered and corrected by using above testing steps and corrections are also noted from the future use.

Validation testing • At the conclusion of integration testing software is completely assembled as a package, interfacing errors have been uncovered and corrected and a final series of software tests begins, validation test begins. • Validation test can be defined in many ways. But the simple definition is that validation succeeds when the software function in a manner that can reasonably expected by the examiners. • After validation test has been conducted one of two possible conditions exists. • One is the function or performance characteristics confirm to specifications and are accepted and the other is deviation from specification is uncovered and a deficiency list is created. • Proposed system under consideration has been tested by using validation testing and found to be working satisfactorily.

Module testing • This is also known as unit testing. Unit testing focuses on the verification of the smallest unit of software design of the module. In this each module was found to be working satisfactory as per the expected output of the module.

Development tools

Data collection • Admin collect the student details ,book details ,attendance details and report details. • Student collect the personalized information and borrow books details.

Thank you