尊敬的 微信汇率:1円 ≈ 0.046166 元 支付宝汇率:1円 ≈ 0.046257元 [退出登录]
SlideShare a Scribd company logo
LIBRARY MANAGEMENT
SYSTEM
Introduction
 Library Management System is a
software used to manages the catalog of a
library.
 This helps to keep the records of whole
transactions of the books available in the
library.
 AmpleTrails provides Library Management
System which is very easy to use and
fulfills all the requirement of a librarian.
Scope of project
 To provide a user friendly envirnoment where user
can be serviced better
 Make functioning of library faster
 To minimize the loss done to book
 To eliminate the paper work in library
 To record every transaction in computerized
system so that problem such as record file missing
won’t be happen.
CONTENTS
1. Entity Relationship Diagram
2. Activity Diagram
3. Use Case Diagram
4. Data Flow Diagram
5. Class Diagram
6. Database Tables
7. Screen Shots
ENTITY RELATION DIAGRAM
 classifying data objects as either entities or
attributes,
 identifying and defining relationships
between entities,
 naming and defining identified entities,
attributes, and relationships,
 documenting this information in the data
document.
Reserve
Reserve-date
Maintain
Keeps
track
Id
STAFF
Name
MEMBERS
Id
Name
F-name
L-name
M-name
Address
Contact no
Login
AUTHETICATION
SYSTEM
User name Password
BOOKS
Author
Publisher
SR no
Price
ISBN
Name
Category
Issue
Issue-date
Return
Return-date
ENTITY RELATIONSHIP DIAGRAM :-
Mem-type
ACTIVITY DIAGRAM
 It captures the dynamic behaviour of the
system.
 Describe the sequence from one activity to
another.
 Describe the parallel, branched and
concurrent flow of the system.
Issue and Return Book :
USE CASE DIAGRAM
 Used to gather requirements of a system.
 Used to get an outside view of a system.
 Identify external and internal factors
influencing the system.
 Show the interacting among the
requirements are actors.
DATA FLOW
 A data flow diagram(DFD) is graphical
representation of the “flow” of data
through an information system.
 A DFD shows what kinds of information will
be input to and output from the system.
 One of the most widely used system
analysis process models is the data flow
diagram.
CLASS DIAGRAM
 Analysis and design of the static view of an
application.
 Describe responsibilities of a system.
 Base for component and deployment
diagrams.
 Forward and reverse engineering.
MEMBER TABLE
Field Name Data Type
mem_id Int(10)
F_name varchar(20)
M_name varchar(20)
L_name varchar(20)
Contact_no varchar(10)
Address varchar(80)
Mem_type varchar(20)
DOB Date
Gender Char(6)
Password varchar(20)
LIBRARY_STAFF TABLE
Field Name Data type
Staff_ID Int(10)
F_name varchar(20)
L_name varchar(20)
Contact_no varchar(20)
DOB Date
Gender Char(6)
Password varchar(20)
BOOK TABLE
Field name Data type
ISBN Int
book_name varchar(20)
Author varchar(20)
Publisher varchar(20)
Price Booelan(20)
category Varchar(20)
ISSUE-RETURN TABLE
Field Name Data Type
ISBN Int
mem_ID Int
Date_issue date
Date_return date
Expiry_date date
THANK YOU !!!

More Related Content

What's hot

online library management system
online library management systemonline library management system
online library management system
Virani Sagar
 
Library management sytem
Library management sytemLibrary management sytem
Library management sytem
ashu6
 
Online Library management system proposal by Banuka Dananjaya Subasinghe
Online Library management system proposal by Banuka Dananjaya SubasingheOnline Library management system proposal by Banuka Dananjaya Subasinghe
Online Library management system proposal by Banuka Dananjaya Subasinghe
BanukaSubasinghe
 
Library Management System
Library Management SystemLibrary Management System
Library Management System
Faculty of Science , portsaid Univeristy
 
Presentation LIBRARY MANAGEMENT SYSTEM
Presentation LIBRARY MANAGEMENT SYSTEM Presentation LIBRARY MANAGEMENT SYSTEM
Presentation LIBRARY MANAGEMENT SYSTEM
binrehmat
 
library management system in SQL
library management system in SQLlibrary management system in SQL
library management system in SQL
farouq umar
 
Library management system
Library management systemLibrary management system
Library management system
Khushboo Taneja
 
Srs library m s
Srs library m sSrs library m s
Srs library m s
karthik venkatesh
 
Library and member management system (lamms) by vikas sharma
Library and member management system (lamms) by vikas sharmaLibrary and member management system (lamms) by vikas sharma
Library and member management system (lamms) by vikas sharma
Vikas Sharma
 
Library Management Project Presentation
Library Management Project PresentationLibrary Management Project Presentation
Library Management Project Presentation
Sanket Kudalkar
 
Library Management system requirements
Library Management system requirementsLibrary Management system requirements
Library Management system requirements
Ahsan Riaz
 
Library management
Library managementLibrary management
Library management
Manoj Jhawar
 
Software Development Methodologies Library Management System (Part-1)
Software Development Methodologies Library Management System (Part-1)Software Development Methodologies Library Management System (Part-1)
Software Development Methodologies Library Management System (Part-1)
Totan Banik
 
Library mangement system project srs documentation.doc
Library mangement system project srs documentation.docLibrary mangement system project srs documentation.doc
Library mangement system project srs documentation.doc
jimmykhan
 
Library Management System
Library Management SystemLibrary Management System
Library Management System
ĞĔŃÚĨŃĔ ĞĔŃĨÚŚ
 
Software requirements specification of Library Management System
Software requirements specification of Library Management SystemSoftware requirements specification of Library Management System
Software requirements specification of Library Management System
Soumili Sen
 
Library management system
Library management systemLibrary management system
Library management system
ABhay Panchal
 
Library management system
Library management systemLibrary management system
Library management system
techlike
 
Library management system
Library management systemLibrary management system
Library management system
Arman Ahmed
 
Library Management System.powerpoint.pptx
Library Management System.powerpoint.pptxLibrary Management System.powerpoint.pptx
Library Management System.powerpoint.pptx
KaiumShuvo1
 

What's hot (20)

online library management system
online library management systemonline library management system
online library management system
 
Library management sytem
Library management sytemLibrary management sytem
Library management sytem
 
Online Library management system proposal by Banuka Dananjaya Subasinghe
Online Library management system proposal by Banuka Dananjaya SubasingheOnline Library management system proposal by Banuka Dananjaya Subasinghe
Online Library management system proposal by Banuka Dananjaya Subasinghe
 
Library Management System
Library Management SystemLibrary Management System
Library Management System
 
Presentation LIBRARY MANAGEMENT SYSTEM
Presentation LIBRARY MANAGEMENT SYSTEM Presentation LIBRARY MANAGEMENT SYSTEM
Presentation LIBRARY MANAGEMENT SYSTEM
 
library management system in SQL
library management system in SQLlibrary management system in SQL
library management system in SQL
 
Library management system
Library management systemLibrary management system
Library management system
 
Srs library m s
Srs library m sSrs library m s
Srs library m s
 
Library and member management system (lamms) by vikas sharma
Library and member management system (lamms) by vikas sharmaLibrary and member management system (lamms) by vikas sharma
Library and member management system (lamms) by vikas sharma
 
Library Management Project Presentation
Library Management Project PresentationLibrary Management Project Presentation
Library Management Project Presentation
 
Library Management system requirements
Library Management system requirementsLibrary Management system requirements
Library Management system requirements
 
Library management
Library managementLibrary management
Library management
 
Software Development Methodologies Library Management System (Part-1)
Software Development Methodologies Library Management System (Part-1)Software Development Methodologies Library Management System (Part-1)
Software Development Methodologies Library Management System (Part-1)
 
Library mangement system project srs documentation.doc
Library mangement system project srs documentation.docLibrary mangement system project srs documentation.doc
Library mangement system project srs documentation.doc
 
Library Management System
Library Management SystemLibrary Management System
Library Management System
 
Software requirements specification of Library Management System
Software requirements specification of Library Management SystemSoftware requirements specification of Library Management System
Software requirements specification of Library Management System
 
Library management system
Library management systemLibrary management system
Library management system
 
Library management system
Library management systemLibrary management system
Library management system
 
Library management system
Library management systemLibrary management system
Library management system
 
Library Management System.powerpoint.pptx
Library Management System.powerpoint.pptxLibrary Management System.powerpoint.pptx
Library Management System.powerpoint.pptx
 

Similar to Library management system

System Data Modelling Tools
System Data Modelling ToolsSystem Data Modelling Tools
System Data Modelling Tools
Liam Dunphy
 
SSAD; TOOLS & TECHNIQUES
SSAD; TOOLS & TECHNIQUESSSAD; TOOLS & TECHNIQUES
SSAD; TOOLS & TECHNIQUES
Malvika Bansal
 
online blood bank system design
online blood bank system designonline blood bank system design
online blood bank system design
Rohit Jawale
 
It 302 computerized accounting (week 2) - sharifah
It 302   computerized accounting (week 2) - sharifahIt 302   computerized accounting (week 2) - sharifah
It 302 computerized accounting (week 2) - sharifah
alish sha
 
MY FIRST PPT
MY FIRST PPTMY FIRST PPT
MY FIRST PPT
Vidhan Dholakia
 
Ch-1-Introduction-to-Database.pdf
Ch-1-Introduction-to-Database.pdfCh-1-Introduction-to-Database.pdf
Ch-1-Introduction-to-Database.pdf
MrjJoker1
 
Accountants can use data flow diagrams (DFDs) to depict the physical.docx
Accountants can use data flow diagrams (DFDs) to depict the physical.docxAccountants can use data flow diagrams (DFDs) to depict the physical.docx
Accountants can use data flow diagrams (DFDs) to depict the physical.docx
renatas0nie
 
Ch08
Ch08Ch08
Ch08
Ch08Ch08
Database management systems
Database management systemsDatabase management systems
Database management systems
Ravindra Singh Gohil
 
Business Analytics Project Example
Business Analytics Project ExampleBusiness Analytics Project Example
Business Analytics Project Example
MBA Capstone Project
 
Dbms
DbmsDbms
Dbms
Tej Kiran
 
Database Concepts & SQL(1).pdf
Database Concepts & SQL(1).pdfDatabase Concepts & SQL(1).pdf
Database Concepts & SQL(1).pdf
rsujeet169
 
Dbms
DbmsDbms
Sql basics
Sql basicsSql basics
Sql basics
Raghu nath
 
M.sc. engg (ict) admission guide database management system 4
M.sc. engg (ict) admission guide   database management system 4M.sc. engg (ict) admission guide   database management system 4
M.sc. engg (ict) admission guide database management system 4
Syed Ariful Islam Emon
 
Database Introduction by Luke Lonergan
Database Introduction by Luke LonerganDatabase Introduction by Luke Lonergan
Database Introduction by Luke Lonergan
Luke Lonergan
 
Ch1- Introduction to dbms
Ch1- Introduction to dbmsCh1- Introduction to dbms
Ch1- Introduction to dbms
Shakila Mahjabin
 
DBMS - Introduction
DBMS - IntroductionDBMS - Introduction
DBMS - Introduction
JOSEPHINE297640
 
Database
DatabaseDatabase
Database
wwaqas2007
 

Similar to Library management system (20)

System Data Modelling Tools
System Data Modelling ToolsSystem Data Modelling Tools
System Data Modelling Tools
 
SSAD; TOOLS & TECHNIQUES
SSAD; TOOLS & TECHNIQUESSSAD; TOOLS & TECHNIQUES
SSAD; TOOLS & TECHNIQUES
 
online blood bank system design
online blood bank system designonline blood bank system design
online blood bank system design
 
It 302 computerized accounting (week 2) - sharifah
It 302   computerized accounting (week 2) - sharifahIt 302   computerized accounting (week 2) - sharifah
It 302 computerized accounting (week 2) - sharifah
 
MY FIRST PPT
MY FIRST PPTMY FIRST PPT
MY FIRST PPT
 
Ch-1-Introduction-to-Database.pdf
Ch-1-Introduction-to-Database.pdfCh-1-Introduction-to-Database.pdf
Ch-1-Introduction-to-Database.pdf
 
Accountants can use data flow diagrams (DFDs) to depict the physical.docx
Accountants can use data flow diagrams (DFDs) to depict the physical.docxAccountants can use data flow diagrams (DFDs) to depict the physical.docx
Accountants can use data flow diagrams (DFDs) to depict the physical.docx
 
Ch08
Ch08Ch08
Ch08
 
Ch08
Ch08Ch08
Ch08
 
Database management systems
Database management systemsDatabase management systems
Database management systems
 
Business Analytics Project Example
Business Analytics Project ExampleBusiness Analytics Project Example
Business Analytics Project Example
 
Dbms
DbmsDbms
Dbms
 
Database Concepts & SQL(1).pdf
Database Concepts & SQL(1).pdfDatabase Concepts & SQL(1).pdf
Database Concepts & SQL(1).pdf
 
Dbms
DbmsDbms
Dbms
 
Sql basics
Sql basicsSql basics
Sql basics
 
M.sc. engg (ict) admission guide database management system 4
M.sc. engg (ict) admission guide   database management system 4M.sc. engg (ict) admission guide   database management system 4
M.sc. engg (ict) admission guide database management system 4
 
Database Introduction by Luke Lonergan
Database Introduction by Luke LonerganDatabase Introduction by Luke Lonergan
Database Introduction by Luke Lonergan
 
Ch1- Introduction to dbms
Ch1- Introduction to dbmsCh1- Introduction to dbms
Ch1- Introduction to dbms
 
DBMS - Introduction
DBMS - IntroductionDBMS - Introduction
DBMS - Introduction
 
Database
DatabaseDatabase
Database
 

Recently uploaded

220711130083 SUBHASHREE RAKSHIT Internet resources for social science
220711130083 SUBHASHREE RAKSHIT  Internet resources for social science220711130083 SUBHASHREE RAKSHIT  Internet resources for social science
220711130083 SUBHASHREE RAKSHIT Internet resources for social science
Kalna College
 
bryophytes.pptx bsc botany honours second semester
bryophytes.pptx bsc botany honours  second semesterbryophytes.pptx bsc botany honours  second semester
bryophytes.pptx bsc botany honours second semester
Sarojini38
 
Contiguity Of Various Message Forms - Rupam Chandra.pptx
Contiguity Of Various Message Forms - Rupam Chandra.pptxContiguity Of Various Message Forms - Rupam Chandra.pptx
Contiguity Of Various Message Forms - Rupam Chandra.pptx
Kalna College
 
How to stay relevant as a cyber professional: Skills, trends and career paths...
How to stay relevant as a cyber professional: Skills, trends and career paths...How to stay relevant as a cyber professional: Skills, trends and career paths...
How to stay relevant as a cyber professional: Skills, trends and career paths...
Infosec
 
Decolonizing Universal Design for Learning
Decolonizing Universal Design for LearningDecolonizing Universal Design for Learning
Decolonizing Universal Design for Learning
Frederic Fovet
 
Accounting for Restricted Grants When and How To Record Properly
Accounting for Restricted Grants  When and How To Record ProperlyAccounting for Restricted Grants  When and How To Record Properly
Accounting for Restricted Grants When and How To Record Properly
TechSoup
 
Post init hook in the odoo 17 ERP Module
Post init hook in the  odoo 17 ERP ModulePost init hook in the  odoo 17 ERP Module
Post init hook in the odoo 17 ERP Module
Celine George
 
A Quiz on Drug Abuse Awareness by Quizzito
A Quiz on Drug Abuse Awareness by QuizzitoA Quiz on Drug Abuse Awareness by Quizzito
A Quiz on Drug Abuse Awareness by Quizzito
Quizzito The Quiz Society of Gargi College
 
pol sci Election and Representation Class 11 Notes.pdf
pol sci Election and Representation Class 11 Notes.pdfpol sci Election and Representation Class 11 Notes.pdf
pol sci Election and Representation Class 11 Notes.pdf
BiplabHalder13
 
Get Success with the Latest UiPath UIPATH-ADPV1 Exam Dumps (V11.02) 2024
Get Success with the Latest UiPath UIPATH-ADPV1 Exam Dumps (V11.02) 2024Get Success with the Latest UiPath UIPATH-ADPV1 Exam Dumps (V11.02) 2024
Get Success with the Latest UiPath UIPATH-ADPV1 Exam Dumps (V11.02) 2024
yarusun
 
Slides Peluncuran Amalan Pemakanan Sihat.pptx
Slides Peluncuran Amalan Pemakanan Sihat.pptxSlides Peluncuran Amalan Pemakanan Sihat.pptx
Slides Peluncuran Amalan Pemakanan Sihat.pptx
shabeluno
 
Creation or Update of a Mandatory Field is Not Set in Odoo 17
Creation or Update of a Mandatory Field is Not Set in Odoo 17Creation or Update of a Mandatory Field is Not Set in Odoo 17
Creation or Update of a Mandatory Field is Not Set in Odoo 17
Celine George
 
managing Behaviour in early childhood education.pptx
managing Behaviour in early childhood education.pptxmanaging Behaviour in early childhood education.pptx
managing Behaviour in early childhood education.pptx
nabaegha
 
INTRODUCTION TO HOSPITALS & AND ITS ORGANIZATION
INTRODUCTION TO HOSPITALS & AND ITS ORGANIZATION INTRODUCTION TO HOSPITALS & AND ITS ORGANIZATION
INTRODUCTION TO HOSPITALS & AND ITS ORGANIZATION
ShwetaGawande8
 
BỘ BÀI TẬP TEST THEO UNIT - FORM 2025 - TIẾNG ANH 12 GLOBAL SUCCESS - KÌ 1 (B...
BỘ BÀI TẬP TEST THEO UNIT - FORM 2025 - TIẾNG ANH 12 GLOBAL SUCCESS - KÌ 1 (B...BỘ BÀI TẬP TEST THEO UNIT - FORM 2025 - TIẾNG ANH 12 GLOBAL SUCCESS - KÌ 1 (B...
BỘ BÀI TẬP TEST THEO UNIT - FORM 2025 - TIẾNG ANH 12 GLOBAL SUCCESS - KÌ 1 (B...
Nguyen Thanh Tu Collection
 
78 Microsoft-Publisher - Sirin Sultana Bora.pptx
78 Microsoft-Publisher - Sirin Sultana Bora.pptx78 Microsoft-Publisher - Sirin Sultana Bora.pptx
78 Microsoft-Publisher - Sirin Sultana Bora.pptx
Kalna College
 
Non-Verbal Communication for Tech Professionals
Non-Verbal Communication for Tech ProfessionalsNon-Verbal Communication for Tech Professionals
Non-Verbal Communication for Tech Professionals
MattVassar1
 
Cross-Cultural Leadership and Communication
Cross-Cultural Leadership and CommunicationCross-Cultural Leadership and Communication
Cross-Cultural Leadership and Communication
MattVassar1
 
The Science of Learning: implications for modern teaching
The Science of Learning: implications for modern teachingThe Science of Learning: implications for modern teaching
The Science of Learning: implications for modern teaching
Derek Wenmoth
 
IoT (Internet of Things) introduction Notes.pdf
IoT (Internet of Things) introduction Notes.pdfIoT (Internet of Things) introduction Notes.pdf
IoT (Internet of Things) introduction Notes.pdf
roshanranjit222
 

Recently uploaded (20)

220711130083 SUBHASHREE RAKSHIT Internet resources for social science
220711130083 SUBHASHREE RAKSHIT  Internet resources for social science220711130083 SUBHASHREE RAKSHIT  Internet resources for social science
220711130083 SUBHASHREE RAKSHIT Internet resources for social science
 
bryophytes.pptx bsc botany honours second semester
bryophytes.pptx bsc botany honours  second semesterbryophytes.pptx bsc botany honours  second semester
bryophytes.pptx bsc botany honours second semester
 
Contiguity Of Various Message Forms - Rupam Chandra.pptx
Contiguity Of Various Message Forms - Rupam Chandra.pptxContiguity Of Various Message Forms - Rupam Chandra.pptx
Contiguity Of Various Message Forms - Rupam Chandra.pptx
 
How to stay relevant as a cyber professional: Skills, trends and career paths...
How to stay relevant as a cyber professional: Skills, trends and career paths...How to stay relevant as a cyber professional: Skills, trends and career paths...
How to stay relevant as a cyber professional: Skills, trends and career paths...
 
Decolonizing Universal Design for Learning
Decolonizing Universal Design for LearningDecolonizing Universal Design for Learning
Decolonizing Universal Design for Learning
 
Accounting for Restricted Grants When and How To Record Properly
Accounting for Restricted Grants  When and How To Record ProperlyAccounting for Restricted Grants  When and How To Record Properly
Accounting for Restricted Grants When and How To Record Properly
 
Post init hook in the odoo 17 ERP Module
Post init hook in the  odoo 17 ERP ModulePost init hook in the  odoo 17 ERP Module
Post init hook in the odoo 17 ERP Module
 
A Quiz on Drug Abuse Awareness by Quizzito
A Quiz on Drug Abuse Awareness by QuizzitoA Quiz on Drug Abuse Awareness by Quizzito
A Quiz on Drug Abuse Awareness by Quizzito
 
pol sci Election and Representation Class 11 Notes.pdf
pol sci Election and Representation Class 11 Notes.pdfpol sci Election and Representation Class 11 Notes.pdf
pol sci Election and Representation Class 11 Notes.pdf
 
Get Success with the Latest UiPath UIPATH-ADPV1 Exam Dumps (V11.02) 2024
Get Success with the Latest UiPath UIPATH-ADPV1 Exam Dumps (V11.02) 2024Get Success with the Latest UiPath UIPATH-ADPV1 Exam Dumps (V11.02) 2024
Get Success with the Latest UiPath UIPATH-ADPV1 Exam Dumps (V11.02) 2024
 
Slides Peluncuran Amalan Pemakanan Sihat.pptx
Slides Peluncuran Amalan Pemakanan Sihat.pptxSlides Peluncuran Amalan Pemakanan Sihat.pptx
Slides Peluncuran Amalan Pemakanan Sihat.pptx
 
Creation or Update of a Mandatory Field is Not Set in Odoo 17
Creation or Update of a Mandatory Field is Not Set in Odoo 17Creation or Update of a Mandatory Field is Not Set in Odoo 17
Creation or Update of a Mandatory Field is Not Set in Odoo 17
 
managing Behaviour in early childhood education.pptx
managing Behaviour in early childhood education.pptxmanaging Behaviour in early childhood education.pptx
managing Behaviour in early childhood education.pptx
 
INTRODUCTION TO HOSPITALS & AND ITS ORGANIZATION
INTRODUCTION TO HOSPITALS & AND ITS ORGANIZATION INTRODUCTION TO HOSPITALS & AND ITS ORGANIZATION
INTRODUCTION TO HOSPITALS & AND ITS ORGANIZATION
 
BỘ BÀI TẬP TEST THEO UNIT - FORM 2025 - TIẾNG ANH 12 GLOBAL SUCCESS - KÌ 1 (B...
BỘ BÀI TẬP TEST THEO UNIT - FORM 2025 - TIẾNG ANH 12 GLOBAL SUCCESS - KÌ 1 (B...BỘ BÀI TẬP TEST THEO UNIT - FORM 2025 - TIẾNG ANH 12 GLOBAL SUCCESS - KÌ 1 (B...
BỘ BÀI TẬP TEST THEO UNIT - FORM 2025 - TIẾNG ANH 12 GLOBAL SUCCESS - KÌ 1 (B...
 
78 Microsoft-Publisher - Sirin Sultana Bora.pptx
78 Microsoft-Publisher - Sirin Sultana Bora.pptx78 Microsoft-Publisher - Sirin Sultana Bora.pptx
78 Microsoft-Publisher - Sirin Sultana Bora.pptx
 
Non-Verbal Communication for Tech Professionals
Non-Verbal Communication for Tech ProfessionalsNon-Verbal Communication for Tech Professionals
Non-Verbal Communication for Tech Professionals
 
Cross-Cultural Leadership and Communication
Cross-Cultural Leadership and CommunicationCross-Cultural Leadership and Communication
Cross-Cultural Leadership and Communication
 
The Science of Learning: implications for modern teaching
The Science of Learning: implications for modern teachingThe Science of Learning: implications for modern teaching
The Science of Learning: implications for modern teaching
 
IoT (Internet of Things) introduction Notes.pdf
IoT (Internet of Things) introduction Notes.pdfIoT (Internet of Things) introduction Notes.pdf
IoT (Internet of Things) introduction Notes.pdf
 

Library management system

  • 2. Introduction  Library Management System is a software used to manages the catalog of a library.  This helps to keep the records of whole transactions of the books available in the library.  AmpleTrails provides Library Management System which is very easy to use and fulfills all the requirement of a librarian.
  • 3.
  • 4. Scope of project  To provide a user friendly envirnoment where user can be serviced better  Make functioning of library faster  To minimize the loss done to book  To eliminate the paper work in library  To record every transaction in computerized system so that problem such as record file missing won’t be happen.
  • 5. CONTENTS 1. Entity Relationship Diagram 2. Activity Diagram 3. Use Case Diagram 4. Data Flow Diagram 5. Class Diagram 6. Database Tables 7. Screen Shots
  • 6. ENTITY RELATION DIAGRAM  classifying data objects as either entities or attributes,  identifying and defining relationships between entities,  naming and defining identified entities, attributes, and relationships,  documenting this information in the data document.
  • 7. Reserve Reserve-date Maintain Keeps track Id STAFF Name MEMBERS Id Name F-name L-name M-name Address Contact no Login AUTHETICATION SYSTEM User name Password BOOKS Author Publisher SR no Price ISBN Name Category Issue Issue-date Return Return-date ENTITY RELATIONSHIP DIAGRAM :- Mem-type
  • 8. ACTIVITY DIAGRAM  It captures the dynamic behaviour of the system.  Describe the sequence from one activity to another.  Describe the parallel, branched and concurrent flow of the system.
  • 10. USE CASE DIAGRAM  Used to gather requirements of a system.  Used to get an outside view of a system.  Identify external and internal factors influencing the system.  Show the interacting among the requirements are actors.
  • 11.
  • 12. DATA FLOW  A data flow diagram(DFD) is graphical representation of the “flow” of data through an information system.  A DFD shows what kinds of information will be input to and output from the system.  One of the most widely used system analysis process models is the data flow diagram.
  • 13.
  • 14.
  • 15. CLASS DIAGRAM  Analysis and design of the static view of an application.  Describe responsibilities of a system.  Base for component and deployment diagrams.  Forward and reverse engineering.
  • 16.
  • 17. MEMBER TABLE Field Name Data Type mem_id Int(10) F_name varchar(20) M_name varchar(20) L_name varchar(20) Contact_no varchar(10) Address varchar(80) Mem_type varchar(20) DOB Date Gender Char(6) Password varchar(20)
  • 18. LIBRARY_STAFF TABLE Field Name Data type Staff_ID Int(10) F_name varchar(20) L_name varchar(20) Contact_no varchar(20) DOB Date Gender Char(6) Password varchar(20)
  • 19. BOOK TABLE Field name Data type ISBN Int book_name varchar(20) Author varchar(20) Publisher varchar(20) Price Booelan(20) category Varchar(20)
  • 20. ISSUE-RETURN TABLE Field Name Data Type ISBN Int mem_ID Int Date_issue date Date_return date Expiry_date date
  • 21.
  • 22.
  • 23.
  • 24.
  • 25.
  翻译: