Library Management System BCA 4th Semester Minor Project using SQL and PHP

ACKNOWLEDGEMENT

We truly resolve to acknowledge the opportunity provided to us by the Institution, respected teachers, and family.

We intend to show our gratitude for all the support and guidance we got from our teachers, classmates, and all individuals who helped us at any point in this project.

This whole process we went through in bringing out this project was a great source of knowledge and valuable experience, which would for sure, come in handy for us in any future we will have to bring out another such project.

This has been a period of time over which we learned about technological and logical aspects of the field where we are going to land soon, we feel indebted for being so well equipped with all the knowledge and experience we gathered here.

Introduction 

Surface details:

Our project entitled “Library Management System” is designed to bring ease to both the library staff and the students seeking for issuing books.

It is designed with features that reduce the effort for the staff and increase convenience for the readers, Being a Web Based application, it is easy to Run and adapt in almost all conventional environments.

Any moderate user can easily learn and operate this system 

Scope:

This System can work fine for all most every library, where desired,

This cuts off a lot of human resources required to maintain the library, hence saving money too.

It has fluid UI and UX which can be learned and adapted quite quickly by any category of user.

This system extends its use outside the library with is easy to adapt interfaces for readers

Objective

The Objective of this System is to reduce effort and increase convenience in the management of libraries.

It allows users to hold a book for 24 hours so that no one can get it issued before they reach the library.

It will save time in the calculation of fine

Students will always stay notified about generated fines via their online accounts which they can access from anywhere.

  • It will make it easier to search for books.
  • It will help keep track of bookholders.
  • It will keep Libraries less crowded.
  • It will save money as fewer human resources will be required.

About the existing system

Currently, libraries need to maintain bulky files to record books and the individuals occupying them.

Fines are calculated manually by going through bundles of records.

Need to manually check for availability of books in the library

The process of issuing a book involves designated officials making entries in registers manually, which takes plenty of time.

Disadvantages of the Present System:

The current system is full of flaws:

  • A lot of Human Resources is required to maintain such a system much cost and hard to operate and maintain.
  • A lot of money is wasted in maintaining these records
  • Paper is wasted
  • A lot of time is consumed in the process of searching a book, making its entry, and retrieving any previous record.
  • Availability of books cannot be assured without physically searching the library
  • People need to travel to the library to know whether a book is available. 

Proposed System

The System we developed comes with all solutions to the drawback of the previous system.

Some of them are listed below:

  • Search books from anywhere.
  • Put the book on hold for 24 hours so that no one else can take it before you
  • Release the book if you don’t want to hold it anymore
  • A panel for users to check their hold and issued books
  • Easy login and registration System.
  • Automated Fine System
  • One-click book Issue
  • Easily return book
  • List of trending books.

Feasibility Study

This document enables proper decisions to be made over the progress of the project, by studying various aspects of feasibility associated with it

Such are listed below:

  • Cost: as it is a web-based project it needs to be hosted over the server to be accessed by users, but the efficiency which comes with the product shadows this cost, as it reduces money being spent on human resources
  • Time: The time invested in this project is also justifiable as keeping the yield into consideration.
  • Technical: All technological tools used to make this project are conventional easy-to-use ones, and they are easy to maintain too.

This project can be easily upgraded and maintained as it is designed in a standard manner and is easy to understand. 

Hardware and software information 

HARDWARE CONFIGURATION

  • System: Multimedia PC
  • Processor:  Pentium 4 or above
  • Memory: 512MB RAM or above
  • Hard Disk:  500GB
  • Keyboard: 104 standards
  • Monitor: SVGA          

SOFTWARE CONFIGURATION

  • Front end: HTML, CSS, JavaScript
  • Back end: SQL, PHP
  • Operating System: Windows/Linux

Design Phase:

ER Diagram:

Context Level Diagram:

First Level Data Flow Diagram:

Second Level Data Flow Diagram for User:

Second Level Data Flow Diagram for Admin:

 

DATA DICTIONARY 

Users Table:

Name

Type

Field-Size

Description

Example

Uid

INT

100

Unique ID for Users

0

name

VARCHAR

100

Name of user

XYZ

password

varchar

100

Password

XYZ

credit

INT

100

No.of books currently Occupied

0-5

U_type

varchar

100

Reader/admin

admin

Pic

varchar

100

photograph

Xyx.jpg

Email

Varchar

100

Email for identification

[email protected]

 

Books Table:

Name

Type

Field-Size

Description

Example

bookid

INT

100

Unique id of book

1

bname

Varchar

100

Name of book

Life of pie

stock

INT

100

Available copies

66

Author

Varchar

100

Name of author

ABC

Publication

Varchar

100

Publication name

BBC

Edition

Varchar

100

Year of publication

2013

Price

Int

100

Price of the book

2000

 Transactions Table:

Name

Type

Field-Size

Description

Example

Tid

INT

100

Unique id of the transaction

1

bid

INT

100

The ID of User Involved

1

uid

INT

100

The ID of Book Involved

1

Time

timestamp

100

Time of transaction

2018-07-02 19:55:11

Returned

INT

100

State(returned or not)

0

T_type

Varchar

100

Hold or issue

issued

Download the complete project on College Library Management System using SQL and PHP.

Leave a Reply

Your email address will not be published. Required fields are marked *