Library Management System PDF

Preview

Summary

School of Science and Technology Faculty of Information Systems and Technology LIBRARY BOOK MANAGEMENT SYSTEM By KWEINGOTI SHADRACK BENARD 631448 Final year project submitted in partial fulfillment of the Requirements for the degree of BSc Information Systems and Technology SPRING 2014 Supervisor DR...

Description

Accelerat ing t he world's research.

Library Management System Shadrack B Kweingoti

Related papers

Download a PDF Pack of t he best relat ed papers 

Dat abase-Driven Library Management Syst em kayode ogunsusi

School of Science and Technology Faculty of Information Systems and Technology LIBRARY BOOK MANAGEMENT SYSTEM By KWEINGOTI SHADRACK BENARD 631448

Final year project submitted in partial fulfillment of the Requirements for the degree of BSc Information Systems and Technology SPRING 2014 Supervisor DR. SILVESTER NAMUYE (Ph.D.)

STATEMENT OF ORIGINALITY I Hereby testify that everything in this project work implementation is written by my own – except the printed or electronic sources I have declared as a citation or as a paraphrase and identified by all the needed bibliographic information. I know that my project work cannot be accepted with undeclared sources and that a plagiarism will cause that I fail the Project Implementation Assignment.

Name of the Student:

Signature of the Student:

Date:

Name of the Supervisor:

Signature of Supervisor:

2|Page

Date:

ACKNOWLEDGEMENT I would like to thank the Almighty God for seeing me through my entire degree program. He kept me strong physically, emotionally, and spiritually. Moreover, He also gave me the wisdom, knowledge, and understanding which enabled me to pursue my degree successfully. I owe special thanks to Dr. Silvester Namuye, Professor of Information Systems and Technology, who was also the supervisor of this project. He shared his vast experience and knowledge, providing the necessary guidance from the start to the end of this project. His advice enabled me to finish this project successfully. Special thanks to my beloved parents, Dr. Reuben Kweingoti, and Mrs. Helen Asami for their unending love and support they have provided me in my entire life. It is through their encouragement and constant prayers that I was able to come this far with my studies. I would like to thank the rest of my family members and my friends for their contribution towards this project. Their advice was very helpful.

3|Page

DEFINITIONS, ACRONYMS, AND ABBREVIATIONS LBMS

Library Book Management System

DBMS

Database Management Systems

GB

Gigabyte

HD

Hard Disk

HTTP

Hyper Text Transmission Protocol

HTML5

Hyper Text Markup Language 5

IEEE

Institute of Electrical & Electronics Engineers

MB

Megabyte

OS

Operating System

PC

Personal Computer

SRS

Software Requirements Specification

SSL

Secure Socket Layer

DFD

Data Flow Diagram

ERD

Entity Relationship Diagram

PHP

Hypertext Processor

MYSQL

Open source database application

TCP/IP

Transmission Control Protocol / Internet Protocol

LAN

Local Area Network

DFD

Data Flow Diagram

ERD

Entity Relationship Diagram

GUI

Graphical User Interface

4|Page

ABSTRACT The advent of diverse information technology systems has revolutionized the way of doing things. A majority of business solutions are automated to meet the changing needs of the end users. Information systems have proved to be effective in implementing the business processes of most organizations and institutions across the globe. Library Book Management System is an online application that was developed and designed with the sole objective of automating library services. The system was intended to address the current problems experienced in Narok county libraries, with an emphasis on Maasai Mara University library which has not fully automated its services. This system aimed at automating the processes of cataloging, book circulation, fine calculation, card processing, member details maintenance, and reports generation. A number of tools were used to implement this system. They include: PHP scripting language, HTML5, JavaScript, JQuery library, Cascading Style Sheets, MySQL 5.3 database running on Wamp Server, Bootstrap, Microsoft Visio 2010, Microsoft Project 2007, Microsoft Office 2010, Adobe Dreamweaver CS6, and Adobe Photoshop CS4. In reference to this system’s objectives, a fully automated library book management system was developed using the aforementioned tools. The system’s performance meets user’s requirements, hence providing the main benefit of concentrating all the library services and functions within the power of a mouse click and feeding of data into the system.

5|Page

TABLE OF CONTENTS STATEMENT OF ORIGINALITY .............................................................................................................. 2 ACKNOWLEDGEMENT ............................................................................................................................ 3 DEFINITIONS, ACRONYMS, AND ABBREVIATIONS ......................................................................... 4 ABSTRACT.................................................................................................................................................. 5 1.

2.

3.

INTRODUCTION .............................................................................................................................. 11 1.1.

Background and Motivation........................................................................................................ 11

1.2.

Problem Statement ...................................................................................................................... 11

1.3.

Project Goal ................................................................................................................................ 12

1.4.

Project Objectives ....................................................................................................................... 12

1.5.

Benefits of the Proposed System ................................................................................................ 12

LITERATURE REVIEW ................................................................................................................... 13 2.1.

Introduction ................................................................................................................................. 13

2.2.

A Look at Automation of Libraries in Institutions of Learning .................................................. 14

2.3.

Functionalities of Automated Library Systems........................................................................... 16

2.4.

Challenges facing Automating Library’s in Kenya .................................................................... 16

2.5.

Conclusion .................................................................................................................................. 17

DESIGN METHODOLOGY .............................................................................................................. 18 3.1.

System feasibility ........................................................................................................................ 18

3.1.1.

Operational feasibility ......................................................................................................... 18

3.1.2.

Technical feasibility ............................................................................................................ 18

3.1.3.

Cultural Feasibility.............................................................................................................. 18

3.1.4.

Economic Feasibility........................................................................................................... 19

3.1.5.

Legal Feasibility.................................................................................................................. 19

3.1.6.

Schedule feasibility ............................................................................................................. 19

3.2.

System Design ............................................................................................................................ 19

3.2.1. 3.3.

System Specification ........................................................................................................... 19

System configuration .................................................................................................................. 19

3.3.1.

System Modules .................................................................................................................. 19

3.3.2.

System Services .................................................................................................................. 20

3.3.2.2.1.

Security ........................................................................................................................... 23

3.3.2.2.2.

Performance .................................................................................................................... 23

3.3.2.2.3.

Reliability ........................................................................................................................ 24

6|Page

3.3.2.2.3.

Portability ........................................................................................................................ 24

3.3.2.2.4.

Usability .......................................................................................................................... 24

3.3.2.2.5.

Friendliness ..................................................................................................................... 24

3.3.2.2.6.

Privacy ............................................................................................................................ 24

3.3.2.2.7.

Extensibility .................................................................................................................... 24

3.3.3. 4.

System Architecture ............................................................................................................ 25

SYSTEM ANALYSIS AND DESIGN ............................................................................................... 27 4.1.

Site Map of the Library Book Management System ................................................................... 27

4.1.1.

Librarian Portal ................................................................................................................... 28

4.1.2.

Member Portal..................................................................................................................... 29

4.2.

Level 0 DFD (Context Diagram) ................................................................................................ 30

4.3.

Level 1 DFD ............................................................................................................................... 31

4.4.

Use Case Diagram....................................................................................................................... 34

4.4.1.

Login Use Case Narration ................................................................................................... 35

4.4.2.

Maintain User Details Use Case Narration ......................................................................... 36

4.4.3.

Maintain Member Details Use Case Narration ................................................................... 38

4.4.4.

Maintain Book Details Use Case Narration ........................................................................ 40

4.4.5.

Lend Book Use Case Narration .......................................................................................... 42

4.4.6.

Return Book Use Case Narration ........................................................................................ 44

4.4.7.

Reserve Book Use Case Narration ...................................................................................... 45

4.4.8.

Search Book Use Case Narration ........................................................................................ 47

4.4.9.

Search Member Use Case Narration ................................................................................... 48

4.4.10.

File Complaint Use Case Narration .................................................................................... 49

4.4.11.

Generate Report Use Case Narration .................................................................................. 50

4.5.

Sequence Diagrams ..................................................................................................................... 51

4.6.1.

Login Sequence Diagram .................................................................................................... 51

4.6.2.

Maintain User Details ......................................................................................................... 52

4.6.3.

Maintain Member Details ................................................................................................... 53

4.6.4.

Maintain Book Details ........................................................................................................ 54

4.6.5.

Issue Book Sequence .......................................................................................................... 55

4.6.6.

Return Book Sequence ........................................................................................................ 56

4.6.7.

Search Book Sequence ........................................................................................................ 57

7|Page

4.6.8.

Reserve Book Sequence ...................................................................................................... 58

4.6.9.

File Complaint Sequence .................................................................................................... 59

4.6.10.

Generate Report Sequence .................................................................................................. 60

4.6.11.

Search Member Sequence ................................................................................................... 61

4.7.

Activity Diagrams ....................................................................................................................... 62

4.7.1.

Login Activity Diagram ...................................................................................................... 62

4.7.2.

Maintain User Details ......................................................................................................... 62

4.7.4.

Generate Report .................................................................................................................. 63

4.7.5.

Issue Book Activity Diagram .............................................................................................. 64

4.7.6.

Return Book Activity Diagram ........................................................................................... 65

4.7.7.

Search Book Activity Diagram ........................................................................................... 66

4.7.8.

Reserve Book Activity Diagram ......................................................................................... 67

4.7.9.

File Complaint Activity Diagram ....................................................................................... 68

4.8.

Conceptual Design ...................................................................................................................... 69

4.9.

Logical Design (Relational Database Schema) ........................................................................... 71

4.10. 5.

Normalization.......................................................................................................................... 78

IMPLEMENTATION AND RESULTS ............................................................................................. 81 5.1.

The Librarian Access Level .......................................................................................................... 83

5.1.1.

Login Form .......................................................................................................................... 83

5.1.2.

Librarian Profile ................................................................................................................... 84

5.1.3.

Add User.............................................................................................................................. 85

5.1.4.

Users List ............................................................................................................................. 86

5.1.5.

Search User Results ............................................................................................................. 86

5.1.6.

Add Member ....................................................................................................................... 87

5.1.7.

Members List....................................................................................................................... 88

5.1.8.

Search Member ................................................................................................................... 89

5.1.9.

Add Member Card............................................................................................................... 90

5.1.10.

List Member Cards .............................................................................................................. 91

5.1.11.

Search Member Card .......................................................................................................... 91

5.1.12.

Print Card ............................................................................................................................ 92

5.1.13.

List Books .............................................................................