Online Library Management System, SRS, PHP MySql Abhishek Bhardwaj, Live demonstration & Coding @ http://abhishekbha...
Online Library Management System Software Requirements Specification itchamps
Version 1.0 27-02-2011
itchamps
Online Library Management System Synopsis Requirements Specification
Version 1.0
Team Name
: itchamps
Team Members : Abhishek Bhardwaj (0806813002) EMail:
[email protected] Anshu Sagar (0806813009) Gaurav Kumar (0806813019) Submitted To : Ms. Anshika Nagpal Course
: B.Tech. (I.T. 6th Semester)
College Name : Meerut Institute Of Enginerring & Technology. Meerut. itchamps, MIET Meerut U.P.
Page 1
Online Library Management System Software Requirements Specification itchamps
State
:
Version 1.0 27-02-2011
Uttar Pradesh
Revision History Date 27-02-2011
itchamps, MIET Meerut U.P.
Version
Description
Author
1.0
First SRS
itchamps
Page 2
Online Library Management System Software Requirements Specification itchamps
Version 1.0 27-02-2011
Table Of Contents Description 1.0
2.0
Page No.
Introduction………………………………………………………05 1.1
Purpose..................................................................................05
1.2
Scope.....................................................................................05
1.3
Definition, Acronyms, and Abbreviations ............................06
1.4
References.............................................................................07
1.5
Technologies to be used........................................................07
1.6
Overview...............................................................................07
Overall Description........…………………………………………08 2.1 Product Perspective..............................................................08 2.2 Software Interface................................................................08 2.3 Hardware Interface...............................................................09 2.4 Communicational Interface.................................................09 2.5 Product Function....……………………...……………...…09 2.6 User Characteristics……………………….………………10 2.7 Constraints……………………….……….………………..10
itchamps, MIET Meerut U.P.
Page 3
Online Library Management System Software Requirements Specification itchamps
Version 1.0 27-02-2011
2.8
Use Case Model Description ……………………………..10
2.9
Database Design…………………………………………...12
2.11 Assumptions & Dependencies…………………………...20
3.0
Specific Requirements…………………………………………21 3.1
State Diagrams as System use case reports…………………………………………………….21
3.2
Supplementary Requirements……………………………33
itchamps, MIET Meerut U.P.
Page 4
Online Library Management System Software Requirements Specification itchamps
Version 1.0 27-02-2011
Software Requirements Specification 1.0 Introduction 1.1 Purpose: Conventionally the readers have to go to library for searching books & magazines and they may have to stand in long reservation lines for reserving/issuing the material. This kind of functionality leads in wastage of time and extra efforts. Here we have provided an online facility through which anyone, anywhere in campus, having a library account can search for and reserve books, find out who is having a particular book and put in a request to library for buying new books.
1.2
Scope: The scope of Online Library Management System includesCreate different system users based on their roles and permissions. Authenticate users at their login. Provide mechanism of searching available books and magazines using title, author name, or field of the book. Facility to reserve books or journals or magazines. An status page for all users to view books or magazines reserved by them, their respective due dates, their respective fines if any. Facility for cancelling a reservation for a book made earlier. Facility for reserving books that are borrowed by others currently. A facility for searching about a user having a particular book and its due date for the same. An interface to review user history. Impose fines on users considering holidays, exams or special leaves. Provide mechanism for changing account settings such as passwords, choosing from different skins & etc. Reports exportable in .XLS, .PDF or any other desirable format.
itchamps, MIET Meerut U.P.
Page 5
Online Library Management System Software Requirements Specification itchamps
Version 1.0 27-02-2011
Place an automated email, on reserving a book, to the user who has currently reserved it and to all of the users who are having that book, stating that the particular book has been reserved. Place requests for purchasing new books to the library, by giving details about the name of the book, name of the author, publisher. Add new book details to the store. Removing particular book details from library.
1.3
Definitions, Acronyms, and Abbreviations: Librarian- He is able to add new books/journals/magazines and remove books from inventory. Users- Those who visits the service for searching, reserving and requesting for a book/journal/magazine. The system is designed for two users students and the faculty. User Detail- Details of an user such as name, id, address, contact number, reserved books, requested books and etc. Book Detail- Details of a book such as its title,publisher,author name, subject or field of book, number of pages etc. HTML- Hyper Text Markup Language. It is used to create static web pages. PHP(Hypertext Processor) - It is used to create dynamic web content. JavaScript- It is a client side scripting language. Mainly use for form validation and interaction between user and html page. AJAX- Asynchronous java script and XML.-used to change page content without reload. MySQL- MySQL Database is the database management system that delivers a flexible and free database platform to build robust on demand business applications.
itchamps, MIET Meerut U.P.
Page 6
Online Library Management System Software Requirements Specification itchamps
Version 1.0 27-02-2011
Apache HTTP Server- Apache HTTP Server is an server that runs business applications and supports the PHP and web services standards. HTTP- Hypertext Transfer Protocol is a transaction oriented client/server protocol between web browser & a Web Server. XML (Extensible Markup Language):-It is a markup language that was designed to transport and store data.
1.4
References: IEEE SRS format Problem Definition(Provided by IBM)
1.5
Tools & Technologies to be used: HTML – Hypertext Markup Language. PHP – Hypertext Processor, a Server-side scripting language. MySQL- MySQL community server, freeware database provided by ORACLE.
AJAX - Asynchronous Java Script and XML. XML - Extension Markup Language. JavaScript – Client-side scripting language. Apache– Apache HTTP server 1.6
Overview Overall Description - will describe major components of the system, interconnection and external interfaces.
Specific Requirements -
will describe the functions of actors, their role in the system and constraints.
itchamps, MIET Meerut U.P.
Page 7
Online Library Management System Software Requirements Specification itchamps
Version 1.0 27-02-2011
2.0 Overall Description Describes the general factors that affect the product and its requirements.
2.1
Product Perspective : The web pages (XHTML/PHP) are present to provide the user interface on client side. Communication between client and server is provided through HTTP/HTTPS protocols. The Client Software is to provide the user interface on system user client side and for this TCP/IP protocols are used. On the server side web server is for PHP and database server is for storing the information.
2.2
Software Interface: Client on Intranet - Web Browser, Operating System (any) Web Server - Apache Http Server, Operating System (Windows based) Data Base Server - MySQL, Operating System (Windows based)
itchamps, MIET Meerut U.P.
Page 8
Online Library Management System Software Requirements Specification itchamps
Version 1.0 27-02-2011
Development End - PHP, MySQL, Windows based OS, Web Server.
2.3
Hardware Interface: Minimum hardware requirements – Client Side Processor
IE6.0 & above, Chrome, Mozilla
Pentium III at
firefox
500MHz
RAM 128 MB
Disk Space 1GB
Server Side – Processor Apache HTTP Server V2.2.17 MySQL V5.5.8
2.4
RAM
Disk Space
Pentium IV at 1.3 GHz
512MB
100MB
Pentium IV at 1.3 GHz
512MB
200MB(Excluding Data Size)
Communication Interface : Client on Internet will be using HTTP/HTTPS protocol.
2.5
Product Functionalities: A Person Should be able to login to the system through the first page of the application and change the password after login into the system. see the status of the books/journals borrowed/reserved by him and the respective due dates and other relevant details search for a particular book/journal based on the name of the book/name of the author/subject/etc and also list for books/journals based on the name of the autor/subject etc
itchamps, MIET Meerut U.P.
Page 9
Online Library Management System Software Requirements Specification itchamps
Version 1.0 27-02-2011
place requests for purchasing new books to the library, by giving details about the name of the book, name of the author, publisher. see who has borrowed a particular book/journal and when is the due date for the same cancel the reservation made earlier for a particular book/journal reserve a particular book/journal borrowed by others currently As soon as a reservation is made for a particular book, an automatic mail should be sent to the person who made the reservation about the details. Then, a mail should be sent to people who are having the book currently, stating a reservation has been made on that book.
Reports exportable in .XLS, .PDF or any other desirable format.
2.6
User Characteristics – Every user should be comfortable of working with computer and net browsing. He must have basic knowledge of English too.
2.7
Constraints – GUI is only in English. Login and password is used for identification of customer and there is no facility for guest.
2.8
Use Case Diagram-
itchamps, MIET Meerut U.P.
Page 10
Online Library Management System Software Requirements Specification itchamps
Version 1.0 27-02-2011
1. Librarian- Responsible for activities such as adding book records, deleting book records, updating book status such as if book is issued & etc.
2. Library Database- Responsible for keeping records of all present & requested books in library. 3. Guest- Registers for a new account for becoming a library member. 4. User- Already registered member who can access library services such as searching books, registering books, requesting for new books and etc.
2.9
Database Design-
itchamps, MIET Meerut U.P.
Page 11
Online Library Management System Software Requirements Specification itchamps
Version 1.0 27-02-2011
ER Diagram-
itchamps, MIET Meerut U.P.
Page 12
Online Library Management System Software Requirements Specification itchamps
Version 1.0 27-02-2011
1 Database library 1.1 Table structure for table books Field
Type
Null Default
id
int(5)
No
name
varchar(100) No
author
varchar(100) No
publisher
varchar(100) No
subject
varchar(50) No
type
varchar(20) No
days
int(3)
No
fine_per_day int(3)
No
copies
int(3)
No
available
int(3)
Yes NULL
1.2 Table structure for table books Field
Type
Null Default
id
int(5)
No
name
varchar(100) No
author
varchar(100) No
publisher
varchar(100) No
subject
varchar(50) No
type
varchar(20) No
days
int(3)
No
fine_per_day int(3)
No
itchamps, MIET Meerut U.P.
Page 13
Online Library Management System Software Requirements Specification itchamps copies
int(3)
No
available
int(3)
Yes NULL
Version 1.0 27-02-2011
1.3 Table structure for table course Field
Type
Null Default
id
int(2)
No
name
varchar(20) No
max_books int(2)
No 0
tbl
Yes NULL
int(2)
1.4 Table structure for table course Field
Type
Null Default
id
int(2)
No
name
varchar(20) No
max_books int(2)
No 0
tbl
Yes NULL
int(2)
1.5 Table structure for table faculty Field
Type
Null Default
uname
varchar(25) No
fname
varchar(20) No
lname
varchar(20) No
email
varchar(25) No
pass
varchar(50) No
reg
char(15)
No
itchamps, MIET Meerut U.P.
Page 14
Online Library Management System Software Requirements Specification itchamps
Version 1.0 27-02-2011
department varchar(25) No photo
varchar(35) No
activated
int(1)
No
1.6 Table structure for table faculty Field
Type
Null Default
uname
varchar(25) No
fname
varchar(20) No
lname
varchar(20) No
email
varchar(25) No
pass
varchar(50) No
reg
char(15)
No
department varchar(25) No photo
varchar(35) No
activated
int(1)
No
1.7 Table structure for table faculty_activity Field Type
Null Default
uname varchar(30) No time
timestamp No CURRENT_TIMESTAMP
status varchar(500) No doc
varchar(100) Yes NULL
1.8 Table structure for table faculty_activity Field Type
Null Default
itchamps, MIET Meerut U.P.
Page 15
Online Library Management System Software Requirements Specification itchamps
Version 1.0 27-02-2011
uname varchar(30) No time
timestamp No CURRENT_TIMESTAMP
status varchar(500) No doc
varchar(100) Yes NULL
1.9 Table structure for table failed_reservations Field
Type
Null Default
bookid
int(3)
No
uname
varchar(30) No
last_rep_date varchar(10) No
1.10 Table structure for table failed_reservations Field
Type
Null Default
bookid
int(3)
No
uname
varchar(30) No
last_rep_date varchar(10) No
1.11 Table structure for table holidays Field
Type
Null Default
date
int(2)
Yes NULL
month
int(2)
Yes NULL
year
int(2)
Yes NULL
description varchar(100) Yes NULL
1.12 Table structure for table holidays Field
Type
Null Default
itchamps, MIET Meerut U.P.
Page 16
Online Library Management System Software Requirements Specification itchamps date
int(2)
Yes NULL
month
int(2)
Yes NULL
year
int(2)
Yes NULL
Version 1.0 27-02-2011
description varchar(100) Yes NULL
1.13 Table structure for table issue Field
Type
Null Default
bookid
int(5)
No
uname
varchar(30) No
return_dd int(2)
No
return_mm int(2)
No
return_yyyy int(4)
No
type
varchar(15) No
1.14 Table structure for table issue Field
Type
Null Default
bookid
int(5)
No
uname
varchar(30) No
return_dd int(2)
No
return_mm int(2)
No
return_yyyy int(4)
No
type
varchar(15) No
1.15 Table structure for table librarian Field Type
Null Default
itchamps, MIET Meerut U.P.
Page 17
Online Library Management System Software Requirements Specification itchamps int(2)
id
Version 1.0 27-02-2011
No
uname varchar(25) No pass
char(50)
No
1.16 Table structure for table librarian Field Type int(2)
id
Null Default No
uname varchar(25) No pass
char(50)
No
1.17 Table structure for table new_book_request Field
Type
Null Default
name
varchar(100) Yes NULL
author
varchar(100) Yes NULL
publisher varchar(100) Yes NULL subject
varchar(100) Yes NULL
time
timestamp No CURRENT_TIMESTAMP
1.18 Table structure for table new_book_request Field
Type
Null Default
name
varchar(100) Yes NULL
author
varchar(100) Yes NULL
publisher varchar(100) Yes NULL subject
varchar(100) Yes NULL
time
timestamp No CURRENT_TIMESTAMP
itchamps, MIET Meerut U.P.
Page 18
Online Library Management System Software Requirements Specification itchamps
Version 1.0 27-02-2011
1.19 Table structure for table reserve Field Type
Null Default
res_id int(10)
No
bookid int(3)
No 0
uname varchar(30) No type
varchar(20) No
dd
int(2)
No
mm
int(2)
No
yyyy
int(4)
No
1.20 Table structure for table reserve Field Type
Null Default
res_id int(10)
No
bookid int(3)
No 0
uname varchar(30) No type
varchar(20) No
dd
int(2)
No
mm
int(2)
No
yyyy
int(4)
No
1.21 Table structure for table student Field
Type
Null Default
uname
varchar(25) No
fname
varchar(20) No
lname
varchar(20) No
itchamps, MIET Meerut U.P.
Page 19
Online Library Management System Software Requirements Specification itchamps email
varchar(25) No
pass
varchar(50) No
reg
char(15)
course
varchar(25) No
photo
varchar(35) No
activated int(1)
Version 1.0 27-02-2011
No
No
1.22 Table structure for table student Field
Type
Null Default
uname
varchar(25) No
fname
varchar(20) No
lname
varchar(20) No
email
varchar(25) No
pass
varchar(50) No
reg
char(15)
course
varchar(25) No
photo
varchar(35) No
activated int(1)
No
No
2.11 Assumptions and Dependencies The end user should have a basic knowledge of English and computer usage. Administrator is created in the system already. Roles and tasks are predefined.
itchamps, MIET Meerut U.P.
Page 20
Online Library Management System Software Requirements Specification itchamps
Version 1.0 27-02-2011
3.
Specific Requirements
3.1
State Diagrams As System Use Reports 3.1.1
State diagram of whole system
Totally 12 windows. All states except "Display Exit Info" can go back to Main Menu. Help Content
Get Help Enter Book Info 14
Add a book
Main Menu 1
Add a student
do/ Insert a student into DB
Enter Student Info 7
Reset
Search students Search books View Mylist
Enter Search Info 2
do/ Insert student into DB
Exit Enter Search Info 11
Update/Delete
Search Display Exit Info Display MyList 5 New Search
exit/ Send from List message
Back Display Results 12
Check In/Out
entry/ Search students in DB
Search Add to list
Add to list Back
Display Book Detail 4
View Detail / UpdateDelete Update,Delete Check In/Out
do/ Update, Delete
Update Detail 60 do/ Update,Delete
Display Results 3
View Detail Check In/Out
entry/ Search books in DB Check In/Out
Enter books. student Info 13 do/ Check In, Check Out
itchamps, MIET Meerut U.P.
Page 21
Online Library Management System Software Requirements Specification itchamps
Version 1.0 27-02-2011
3.1.2 Activity diagram of each operation
Student class
•
AddStudent : add a new student
validat eStudent
[ exists ]
return error message
[ not exist s ]
add the student record to Student table
•
return success message
DeleteStudent : delete an existing student
validat eStudent
[ not exist s ]
return error message
[ exists ]
delete t he student record to Student table
•
return success message
UpdateStudent : update information of existing student
itchamps, MIET Meerut U.P.
Page 22
Online Library Management System Software Requirements Specification itchamps
Version 1.0 27-02-2011
Update the student record in the Student table
•
SearchStudent : search students
Query the student record in Student table
return Resultset
•
ValidateStudent : validate student
itchamps, MIET Meerut U.P.
Page 23
Online Library Management System Software Requirements Specification itchamps
Version 1.0 27-02-2011
Query the student in Student table according to studentID
Return Resultset
[ not empty ]
Ret urn true
[ empty ]
Return false
itchamps, MIET Meerut U.P.
Page 24
Online Library Management System Software Requirements Specification itchamps
Version 1.0 27-02-2011
Book class
addBook: Add a new book in database
Check Book record in database
exist
yes
Return "Book already exist" message
no Insert book record in database
return success message
itchamps, MIET Meerut U.P.
Page 25
Online Library Management System Software Requirements Specification itchamps
Version 1.0 27-02-2011
exist: Check if the book record already exist in database.
Search Book record in database
found record?
no
return not exist message
yes return exist message
itchamps, MIET Meerut U.P.
Page 26
Online Library Management System Software Requirements Specification itchamps
Version 1.0 27-02-2011
searchBook: Search books in database
search book record in database
return resultset
updateBook: modify book info
update record in database
return success message
itchamps, MIET Meerut U.P.
Page 27
Online Library Management System Software Requirements Specification itchamps
Version 1.0 27-02-2011
deleteBook: Delete a book in database
check existence
exist?
no
yes
delete the record
return fail message
return success message
itchamps, MIET Meerut U.P.
Page 28
Online Library Management System Software Requirements Specification itchamps
Version 1.0 27-02-2011
Transaction class
checkIn() : check in one book
SQL Statement (Update.....)
Exception? No return true
itchamps, MIET Meerut U.P.
Yes Print "error message"
ret urn false
Page 29
Online Library Management System Software Requirements Specification itchamps
Version 1.0 27-02-2011
checkOut() : check out one book
SQL Statement (Update.....)
Exception? No return true
itchamps, MIET Meerut U.P.
Yes Print "error message"
ret urn false
Page 30
Online Library Management System Software Requirements Specification itchamps
Version 1.0 27-02-2011
MyList class
addTolist() : add one book to mylist
SQL Statement (Insert.....)
Exception? No return true
itchamps, MIET Meerut U.P.
Yes Print "error message"
ret urn false
Page 31
Online Library Management System Software Requirements Specification itchamps
Version 1.0 27-02-2011
deleteFromList() : delete one book from mylist
SQL Statement (Delete.....)
Exception? No return true
itchamps, MIET Meerut U.P.
Yes Print "error message"
ret urn false
Page 32
Online Library Management System Software Requirements Specification itchamps
Version 1.0 27-02-2011
Mylist.viewList() : retrieve books in mylist
SQL Statement (Select....)
Exception? No return true
3.2
Yes Print "error message"
ret urn false
Supplementary Requirements 24 x 7 Availability - If the base is now the entire world, staying open 24 hours a day becomes critical. Because system can be an automated Process, so it can stay open for 24 hours a day. So UPS support must be on server site for at least 8 hours in case of power failure. System will remain inaccessible to users at 2:00 to 4:00 am for backup and maintenance purpose. Dynamic Website - Many early Web implementations consisted of static HTML pages. This becomes very difficult to manage if the number of pages gets too large. An effective system should be largely dynamic taking advantage of technology that automates this process rather than relying on manual processes. Application should serve dynamic user based customized web pages to its clients from server.
Integration with existing enterprise systems – Any existing Web site that relies on the manual duplication of data from another system is one that can be improved. Most of the business data in the world today exists in enterprise servers that can be connected to the Web servers to make this process far more effective.
itchamps, MIET Meerut U.P.
Page 33
Online Library Management System Software Requirements Specification itchamps
Version 1.0 27-02-2011
Provide good performance and the ability to scale the server – The Web application Server should provide good performance and the ability to manage performance with techniques, such as support for caching, clustering, and load balancing. Providing session management capability - Web application developers should not spend valuable time worrying about how to maintain sessions within the application. The Web Application Server should provide these services.
itchamps, MIET Meerut U.P.
Page 34