Developing An Online Library Management System Computer Science Essay

Published:

This project is aimed at developing an online Library Management System for the college library. I proposed to develop an application that will be able to manage all the functions related to library in more secure and easy and friendly environment. It covers all the aspects in the Library management system (Users, librarian, Library) and also the billing system and security systems which are related to librarian and the database.

This system can be used to search for books/magazines, reserve books, find out who is having a particular book, put in requests to buy a new book etc. This is one integrated system that contains both the user component and the librarian component. This system is Intranet based can be used though out the campus where there is access to internet. There are features like paying charges for the late submissions through the system.

In this report I also explained the security considerations I have focused while designing the application and the test scenarios undertaken to test the functionality of application. In the end I conclude with the possible scope that might take me to develop a commercial Library Management System.

1. Brief process description:

Lady using a tablet
Lady using a tablet

Professional

Essay Writers

Lady Using Tablet

Get your grade
or your money back

using our Essay Writing Service!

Essay Writing Service

The Library Management System is designed & developed for a receipt and issuance of books in the library along with the student’s details. The books received in the library are entered in Books Entry form and the new student is entered in the student entry form. When the student wants to get the desired book the same is issued on the availability basis to the student. The issuance and due date for the returning of the book is also entered into the Book Issue form under third menu Book Issue. The student has to pay the fine if any on the basis of no. of days delayed deposit of the book in the library.

problems with existing system

Fast reporting may not be possible.

Retrieving login details is possible for the administrator not the user

Much complicated system

Tracking a book may be difficult.

Members feel difficulty in paying fine.

proposed system metrics

It should provide efficient service to members

Easy access to contact the administrator

Can pay the fine in the system without difficulty

Maintaining proper records of the books.

Chapter 2

Design plan:

The system is designed in such a way that it can cover all the operations in daily library management functionality. It starts with the login page to authenticate the user to enter home page of the application. On the login page it consists of register, forgotten login details etc. After the authentication on the home page it consists of help, settings, reports, search, request books, buy books, pay fine etc. And for the librarian there are special modules for maintaining the user data, maintaining the books, maintaining transactions, issuing the books etc.

Table 1:

User:

User:

functions

login

Change personal details

Search for books journals

Request books

Order books

Pay fines

Help

Check personal messages

Librarian:

Librarian

Functions:

Maintain user data

Maintain books and journals

Maintain transactions

Issue books

Maintain fine details

Update user details and new books

Maintain Dates for books issued

Table design:

Issue:

S.No

Field name

Data type

1

Book no

Number

2

id

Number

3

Book_name

Name

4

Issue_date

Date/time

5

Due_date

Date/time

6

Copies vailable

Number

User:

S.No

Field name

Data type

1

id

Number

2

name

text

3

Roll number

number

4

Branch

Text

5

Contact details

Number/text

Book:

S.No

Field name

Data type

1

Book_num

Number

2

ISBN

Number

3

subject

Text

4

Name

Text

5

Author

Text

6

publisher

Lady using a tablet
Lady using a tablet

Comprehensive

Writing Services

Lady Using Tablet

Plagiarism-free
Always on Time

Marked to Standard

Order Now

Text

7

Editor

Text

8

copies

Number

9

cost

Number

Issue_return:

S.No

Field name

Data type

1

Book no

Number

2

id

Number

3

Issue date

Date/time

4

Due_date

Date/time

5

fine

Number

6

Copies available

number

Login page:

Login page is the gate to access the whole application in a secure manner. This page authenticates the user whether he/she authorized to access the application or not. When a person tries to access this application this page asks the user to enter authorized user name and password. All the usernames and passwords only can create and issued by administrator who is high level authority in the organization. Login page also provide a very useful feature to change password or in case forgot any login details by clicking forgotten login details button. We have two more buttons in this page, on is login button to enter home page and second one is cancel button to cancel login.

When user click login button by entering the correct username and password, the application check the details with the fields of login table in MS Access database. If username and password matches the one in database it allows the user to enter the database to access the application. If we click forgotten login details button it will take to other page where the details of user is asked and further a new password is given by the administrator.

Home page:

Add members:

Stock maintenance:

Issue books:

Return books:

Technology used:

3.1 java:

Java is programming language developed by James Gosling at Sun Microsystems. The main features of java are as follows:

platform independent (write-once-run-anywhere)

simple (it does not use pointers explicitly)

Object oriented

Robust (powerful exceptional handling and type checking mechanism)

Distributed

Portable(can get files dynamically from computers thousand miles away)

Secure (uses public key encryption system)

Performance (

Multi-threaded etc.

For a language to be object oriented to should it should follow four characters:

Inheritance

Encapsulation

Polymorphism

Dynamic binding

3.2 HTML:

It stands for Hyper Text Mark-up Language

By using HTML we can design the basic frame of webpage. It has the mechanisms like style sheets scripting frames, embedding objects.

3.3 Database used:

To develop this application I have used Microsoft Access to store the all school related data. It is a relational database management system from Microsoft with a graphical user interface and software development tools. It is used to create simple database solutions. MS Access can be used through technologies like ODBC (Open Database Connectivity) or OLE DB (Object linking and Embedding, Database). The data stored in MS Access database can be accessed by web applications based on .NET framework, Java or PHP

4. Testing the software:

Testing process is important stage in the software system. Testing is process for validating a software program or application whether it meets the technical requirements that guided in the design. System testing is a process of testing whole application by considering user requirements, functional requirements. It tests the application by taking internal parts as input to test the entire system step by step. In system testing, we should require no knowledge of inner design or coding logic. (Wikipedia)

System testing can be performed by following process

Functionality testing

Usability testing

Security testing

Performance testing

Compatibility testing

Installation testing etc.

4.1 User Acceptance Testing

Acceptance testing is the process of testing the core functionalities of an application as per the user requirements. This test process is done prior to delivery of an application to customer. User acceptance testing comes under black box testing, i.e., there is no need knowledge about internal coding logic to test the application. (Jeffrey Rubin, 1994)6

4.2 Unit Testing

Unit testing is the process of testing an application by considering test object as small entities like classes, interfaces or a block of code. Normally, this process is done by developers in development phase of an application. Unit testing fall under white box testing because the person who is unit testing an application should have knowledge of coding logic. (Scott Loveland, 2005)9

Lady using a tablet
Lady using a tablet

This Essay is

a Student's Work

Lady Using Tablet

This essay has been submitted by a student. This is not an example of the work written by our professional essay writers.

Examples of our work

For this School management application I have completed the Unit testing process while I am developing this application. To test the functionality of this application I am going to perform System Testing in the following manner.

4.3 Test Data

Gathering the test data is the first phase in testing the application. The test data gathered from various sources should be sufficient to test the entire system functionality. For this school management system application, I have collected the test data mostly from my real knowledge as per my understanding of school environment and some examples from the internet.

4.4 Test Plan

Test plan gives a clear idea of how we planning to test the entire system functionality. It covers the Testing scope, Assumptions and Dependencies, Risks and Mitigations, System Testing Entry and Exit Criteria, QA Deliverables and QA Schedule.

Referred considerations:

Referred the functionality requirements

Referred school environment requirements

Project time Management:

There are no major delays in planning and allocating the schedules for the tasks. Some of the delays occurred are shown in chart below.

Tasks

Overview of the project

Planning the design process

Gathering software needed and installing it

Application design

Design implementation

Application testing and conclusion

Preparing Final Report