Online Library Management System, SRS, PHP MySql Abhishek ...

May 31, 2017 | Author: Anonymous | Category: PHP, MySQL
Share Embed


Short Description

Online Library Management System, SRS, PHP MySql Abhishek Bhardwaj, Live demonstration & Coding @ http://abhishekbha...

Description

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

View more...

Comments

Copyright © 2017 DATENPDF Inc.