Computerized Library Management System

Data Flow Diagram of Existing System

Scopes

Limitations

End

• Log-in Module
• Main Module
• Search Module
• Transaction Module
• Print Module
• Student Module
• Return Module
• Transaction Expires Module

• Integrated
• Online

Methodology

Spiral Model

Data Dictionary

Renew=Renew1+Renew2+Renew3

Renew1={0-9|-}

Renew2={0-9|-}

Renew3={0-9|-}

RenewDueDate = RenewDueDate1 +RenewDueDate2 + RenewDueDate3

RenewDueDate1={0-9|-}

RenewDueDate2={0-9|-}

RenewDueDate3={0-9|-}

RenewReturnedDate=RenewReturnedDate1+RenewReturnedDate2+RenewReturnedDate3

RenewReturnedDate1={0-9|-}

RenewReturnedDate2={0-9|-}

RenewReturnedDate3={0-9|-}

FinesPHP = {0-9}

Personnel In-Charge = {A-Z|a-z}

Summary

Admin Account = Username + Password

Username = {A-Z|a-z|0-9|}

Password = {A-Z|a-z|0-9|}

Books =BookCode + CallCode + BookName + Author + YearPublished + Publisher + Quantity + ISBN + Subject + Date Acquired + Cost + Invoice

BookCode = {0-9}

CallCode = {A-Z|a-z|0-9}

Bookname = {A-Z|a-z|0-9}

Author = {A-Z|a-z|0-9}

YearPublished = {0-9}

Publisher = {A-Z|a-z|0-9}

Quantity ={0-9}

ISBN = {A-Z|a-z|0-9}

Subject = {A-Z|a-z|0-9}

Date Acquired = {A-Z|a-z|0-9}

Cost = {0-9}

Invoice = {A-Z|a-z|0-9}

Student = StudentNumber + StudentName +StudentCourse +BookNumbers + Books+ BorrowedDate + DueDate + ReturnedDate+RenewDate+ RenewDueDate + RenewReturnedDate + FinesPHP + Personnel In-Charge

StudentNumber={0-9}

StudentName={A-Z|a-z|0-9|-}

StudentCourse={A-Z|a-z|}

Hipo Chart

Current State of Technology

Objectives

General Objectives

BookCode = BookCode1 + BookCode2 + BookCode3

BookCode1={A-Z|a-z|0-9|}

BookCode2={A-Z|a-z|0-9}

BookCode3-{A-Z|a-z|0-9}

Books=Book1+Book2+Book3

Book1={A-Z|a-z|0-9|}

Book2={A-Z|a-z|0-9}

Book3-{A-Z|a-z|0-9}

BorrowedDate = BorrowedDate1 + BorrowedDate2 + BorrowedDate3

BorrowedDate1={0-9|-}

BorrowedDate2={0-9|-}

BorrowedDate3={0-9|-}

DueDate=DueDate1+DueDate2+DueDate3

DueDate1={0-9|-}

DueDate2={0-9|-}

DueDate3={0-9|-}

ReturnedDate=ReturnedDate1+ReturnedDate2+ReturnedDate3

ReturnedDate1={0-9|-}

ReturnedDate2={0-9|-}

ReturnedDate3={0-9|-}

To develop a Computerized Library Management System for STI Academic Center Caloocan.

In their manual process student must need to register to get a library card and when they already have a library card they can borrow during library hours but the library can only accommodate 1 book per student, students can borrow the book for only 1 day. There’s a penalty if they can’t bring the book back to the said date.

To create a module that will monitor the available/unavailable books.

To create a module that will allow the students to borrow and return books.

Database Manager

To develop a system that will notify the librarians who are the students that exceed the duration of day in borrowing of books.

Microsoft Access

Child Diagram 3.0

Child Diagram 1.0

Child Diagram 2.0

Specific Problem

How to create a module that will monitor the available/unavailable books?

Dacudao, Ronner J.

Gregorio, Alfie D.

Nocum, Christian Alex H.

Pagilagan, Darwin T.

How to create a module that will allow the student borrowed and returned books?

How will the librarians determine those students who exceed on duration of days of borrowing books?

Programming Language

Microsoft Visual Basic 6

System Design Specification

Data Flow Diagram

Entity Relationship Diagram

Context Diagram

Diagram 0

Statement of the Problem

General Problem

How will the proposed system help to solve the problem in Library of STI Academic Center Caloocan?

Chapter 2

Introduction

• Research
• Concepts
• Additional Information
• Features
• Internet
• Interview

Chapter 1

Computerized Library Management System

Introduction

Chapter 3

Computerized Library Management System