System Analysis and Design for Wenty Library Management System

This document provides a system analysis and design for Wenty Library Management System. It includes use case diagram, data flow diagram, entity relationship diagram, interfaces, Gantt chart, and project scope and cost analysis.

Running head: SYSTEM ANALYSIS AND DESIGN
System Analysis and Design
Name of the Student
Name of the University
Author’s note:

1SYSTEM ANALYSIS AND DESIGN
Table of Contents
System Justification:........................................................................................................................2
Business Case and System Implementation Business Benefits:......................................................2
Project Scope and Cost and Schedule Analysis:..............................................................................3
Use Case Diagram:..........................................................................................................................9
Data Flow Diagram:......................................................................................................................10
Entity Relationship Diagram:........................................................................................................12
Interfaces:......................................................................................................................................13
Gantt Chart:...................................................................................................................................15
Bibliography:.................................................................................................................................16

2SYSTEM ANALYSIS AND DESIGN
System Justification:
The proposed system will allow the Wenty Library efficiently and effectively manager
data. The librarian, management and members will be informed and updated all the time. The
librarian will be able to track borrow of books and returns easily. The organization has 15000
copies of books in their Wenty Library. Keeping track of the all the books is hard for the
librarian. The management does not get accurate and complete reports on existing members,
borrow of books and availability of books. The manual paper based works are prone to error and
often has inaccurate data.
The system will introduce automatic completion of back office processes. The system
will track a book from its entry to the Wenty Library to returns from the members. The system
can track the publisher, author and copy of each book simultaneously. This will allow the
librarian and members to search for books through various keywords. The system will also
generate fines for books renting automatically. Thus the system handles all the processes of the
Wenty Library accurately and provide enough support to each stakeholder.
Business Case and System Implementation Business Benefits:
The selected organization is Wenty Library that handles and monitors the daily
transaction of the Wenty Library. The organization registers new members into the system. The
system allows only the librarian to rent a book using a book renting form. The members can
login to the system using email and password to check their history of renting books and
associated fines. The business needs reports so that right decisions can be made. Wenty Library
also like to add, update and delete from library that must be reflected on the system.
The business will have following benefits from the proposed library management system.

3SYSTEM ANALYSIS AND DESIGN
i. Tracking of book rentals easily
ii. Easy report generation
iii. Accurate data will allow better decision making
iv. Increase member satisfaction due to availability of information
v. Increase profit as the operational cost will reduce significantly
Project Scope and Cost and Schedule Analysis:
The project scope are as following.
i. Handling the registration of the members
ii. Handling the book management
iii. A system that can track book rental process without human interaction
iv. A system that generates report automatically
v. Recording book, member and borrow process related information in database
WBS Task Name Duration Start Finish Predecessors Cost
Resource
Names
0
Wenty Library
System
Development
Project
81 days
Wed
5/29/19
Wed
9/18/19
$132,736.00
1 Sprint 1 10 days
Wed
5/29/19
Tue
6/11/19
$15,912.00

4SYSTEM ANALYSIS AND DESIGN
1.1 Sprint Planning 1 day
Wed
5/29/19
Wed
5/29/19
$1,560.00
End
User,Project
Owner,Scrum
Master
1.2
Create Member
login/register
2 days
Thu
5/30/19
Fri
5/31/19
2 $3,408.00 Agile Team
1.3
Connect
Librarian
login/registration
3 days
Mon
6/3/19
Wed
6/5/19
3 $5,112.00 Agile Team
1.4 Testing 1 day
Thu
6/6/19
Thu
6/6/19
4 $1,864.00
Agile
Team,End
User
1.5 Fix period 2 days
Fri
6/7/19
Mon
6/10/19
5 $3,408.00 Agile Team
1.6 Deploy 1 day
Tue
6/11/19
Tue
6/11/19
6 $560.00 Scrum Master
2 Sprint 2 9 days
Wed
6/12/19
Mon
6/24/19
$14,208.00
2.1 Sprint Planning 1 day Wed
6/12/19
Wed
6/12/19
7 $1,560.00 End
User,Project
Owner,Scrum

5SYSTEM ANALYSIS AND DESIGN
Master
2.2
Create Main
Menu
1 day
Thu
6/13/19
Thu
6/13/19
9 $1,704.00 Agile Team
2.3
Create Home.
Contact and About
Page
3 days
Fri
6/14/19
Tue
6/18/19
10 $5,112.00 Agile Team
2.4 Testing 1 day
Wed
6/19/19
Wed
6/19/19
11 $1,864.00
Agile
Team,End
User
2.5 Fix period 2 days
Thu
6/20/19
Fri
6/21/19
12 $3,408.00 Agile Team
2.6 Deploy 1 day
Mon
6/24/19
Mon
6/24/19
13 $560.00 Scrum Master
3 Sprint 3 15 days
Tue
6/25/19
Mon
7/15/19
$24,448.00
3.1 Sprint Planning 2 days
Tue
6/25/19
Wed
6/26/19
14 $3,120.00
End
User,Project
Owner,Scrum
Master
3.2 Create Book 3 days Thu Mon 16 $5,112.00 Agile Team

6SYSTEM ANALYSIS AND DESIGN
Page 6/27/19 7/1/19
3.3
Create Searching
Options
2 days
Tue
7/2/19
Wed
7/3/19
17 $3,408.00 Agile Team
3.4
Add Buttons and
Links
1 day
Thu
7/4/19
Thu
7/4/19
18 $1,704.00 Agile Team
3.5 Testing 2 days
Fri
7/5/19
Mon
7/8/19
19 $3,728.00
Agile
Team,End
User
3.6 Fix period 4 days
Tue
7/9/19
Fri
7/12/19
20 $6,816.00 Agile Team
3.7 Deploy 1 day
Mon
7/15/19
Mon
7/15/19
21 $560.00 Scrum Master
4 Sprint 4 21 days
Tue
7/16/19
Tue
8/13/19
$34,672.00
4.1 Sprint Planning 2 days
Tue
7/16/19
Wed
7/17/19
22 $3,120.00
End
User,Project
Owner,Scrum
Master
4.2 Create Cart 3 days
Thu
7/18/19
Mon
7/22/19
24 $5,112.00 Agile Team

7SYSTEM ANALYSIS AND DESIGN
4.3
Create Book
Borrow Management
4 days
Tue
7/23/19
Fri
7/26/19
25 $6,816.00 Agile Team
4.4
Create Book
Add, Update and
Delete Options
4 days
Mon
7/29/19
Thu
8/1/19
26 $6,816.00 Agile Team
4.5 Testing 2 days
Fri
8/2/19
Mon
8/5/19
27 $3,728.00
Agile
Team,End
User
4.6 Fix period 5 days
Tue
8/6/19
Mon
8/12/19
28 $8,520.00 Agile Team
4.7 Deploy 1 day
Tue
8/13/19
Tue
8/13/19
29 $560.00 Scrum Master
5 Sprint 5 26 days
Wed
8/14/19
Wed
9/18/19
$43,496.00
5.1 Sprint Planning 1 day
Wed
8/14/19
Wed
8/14/19
30 $1,560.00
End
User,Project
Owner,Scrum
Master
5.2
Create Book
Return Management
4 days
Thu
8/15/19
Tue
8/20/19
32 $6,816.00 Agile Team
5.3 Add Fine 4 days Wed Mon 33 $6,816.00 Agile Team

8SYSTEM ANALYSIS AND DESIGN
Calculation Process 8/21/19 8/26/19
5.4
Create Report
Generating Options
7 days
Tue
8/27/19
Wed
9/4/19
34 $11,928.00 Agile Team
5.5 Testing 3 days
Thu
9/5/19
Mon
9/9/19
35 $5,592.00
Agile
Team,End
User
5.6 Fix period 6 days
Tue
9/10/19
Tue
9/17/19
36 $10,224.00 Agile Team
5.7 Deploy 1 day
Wed
9/18/19
Wed
9/18/19
37 $560.00 Scrum Master

9SYSTEM ANALYSIS AND DESIGN
Use Case Diagram:
Figure 1: Use Case Diagram of Management System
(Source: Created by Author)

10SYSTEM ANALYSIS AND DESIGN
Data Flow Diagram:
Figure 2: Context Level Diagram of Management System
(Source: Created by Author)

11SYSTEM ANALYSIS AND DESIGN
Figure 3: Level 0 DFD of Management System
(Source: Created by Author)

12SYSTEM ANALYSIS AND DESIGN
Entity Relationship Diagram:
Figure 4: Entity Relationship Diagram of Management System Database
(Source: Created by Author)

13SYSTEM ANALYSIS AND DESIGN
Interfaces:
Figure 5: Home Page (Main Menu)
(Source: Created by Author)

14SYSTEM ANALYSIS AND DESIGN
Figure 6: Input Page
(Source: Created by Author)
Figure 7: Report Page
(Source: Created by Author)

15SYSTEM ANALYSIS AND DESIGN
Gantt Chart:
ID WBS Task Name Duration Start Finish Predecessors Cost Resource Names
0 0 Library System Development Project 81 days Wed
5/29/19
Wed
9/18/19
$132,736.00
1 1 Sprint 1 10 days Wed 5/29/19Tue 6/11/19 $15,912.00
2 1.1 Sprint Planning 1 day Wed 5/29/19Wed 5/29/19 $1,560.00 End User,Project Owner,Scrum Master
3 1.2 Create Member login/register 2 days Thu 5/30/19Fri 5/31/19 2 $3,408.00 Agile Team
4 1.3 Connect Librarian login/registration 3 days Mon 6/3/19 Wed 6/5/19 3 $5,112.00 Agile Team
5 1.4 Testing 1 day Thu 6/6/19 Thu 6/6/19 4 $1,864.00 Agile Team,End User
6 1.5 Fix period 2 days Fri 6/7/19 Mon 6/10/195 $3,408.00 Agile Team
7 1.6 Deploy 1 day Tue 6/11/19Tue 6/11/196 $560.00 Scrum Master
8 2 Sprint 2 9 days Wed 6/12/19Mon 6/24/19 $14,208.00
9 2.1 Sprint Planning 1 day Wed 6/12/19Wed 6/12/197 $1,560.00 End User,Project Owner,Scrum Master
10 2.2 Create Main Menu 1 day Thu 6/13/19Thu 6/13/199 $1,704.00 Agile Team
11 2.3 Create Home. Contact and About Page 3 days Fri 6/14/19 Tue 6/18/1910 $5,112.00 Agile Team
12 2.4 Testing 1 day Wed 6/19/19Wed 6/19/1911 $1,864.00 Agile Team,End User
13 2.5 Fix period 2 days Thu 6/20/19Fri 6/21/19 12 $3,408.00 Agile Team
14 2.6 Deploy 1 day Mon 6/24/19Mon 6/24/1913 $560.00 Scrum Master
15 3 Sprint 3 15 days Tue 6/25/19Mon 7/15/19 $24,448.00
16 3.1 Sprint Planning 2 days Tue 6/25/19Wed 6/26/1914 $3,120.00 End User,Project Owner,Scrum Master
17 3.2 Create Book Page 3 days Thu 6/27/19Mon 7/1/19 16 $5,112.00 Agile Team
18 3.3 Create Searching Options 2 days Tue 7/2/19 Wed 7/3/19 17 $3,408.00 Agile Team
19 3.4 Add Buttons and Links 1 day Thu 7/4/19 Thu 7/4/19 18 $1,704.00 Agile Team
20 3.5 Testing 2 days Fri 7/5/19 Mon 7/8/19 19 $3,728.00 Agile Team,End User
21 3.6 Fix period 4 days Tue 7/9/19 Fri 7/12/19 20 $6,816.00 Agile Team
22 3.7 Deploy 1 day Mon 7/15/19Mon 7/15/1921 $560.00 Scrum Master
23 4 Sprint 4 21 days Tue 7/16/19Tue 8/13/19 $34,672.00
24 4.1 Sprint Planning 2 days Tue 7/16/19Wed 7/17/1922 $3,120.00 End User,Project Owner,Scrum Master
25 4.2 Create Cart 3 days Thu 7/18/19Mon 7/22/1924 $5,112.00 Agile Team
26 4.3 Create Book Borrrow Management 4 days Tue 7/23/19Fri 7/26/19 25 $6,816.00 Agile Team
27 4.4 Cretae Book Add, Update and Delete Options4 days Mon 7/29/19Thu 8/1/19 26 $6,816.00 Agile Team
28 4.5 Testing 2 days Fri 8/2/19 Mon 8/5/19 27 $3,728.00 Agile Team,End User
29 4.6 Fix period 5 days Tue 8/6/19 Mon 8/12/1928 $8,520.00 Agile Team
30 4.7 Deploy 1 day Tue 8/13/19Tue 8/13/1929 $560.00 Scrum Master
31 5 Sprint 5 26 days Wed 8/14/19Wed 9/18/19 $43,496.00
32 5.1 Sprint Planning 1 day Wed 8/14/19Wed 8/14/1930 $1,560.00 End User,Project Owner,Scrum Master
33 5.2 Create Book Return Management 4 days Thu 8/15/19Tue 8/20/1932 $6,816.00 Agile Team
34 5.3 Add Fine Calculation Process 4 days Wed 8/21/19Mon 8/26/1933 $6,816.00 Agile Team
35 5.4 Create Report Generating Options 7 days Tue 8/27/19Wed 9/4/19 34 $11,928.00 Agile Team
36 5.5 Testing 3 days Thu 9/5/19 Mon 9/9/19 35 $5,592.00 Agile Team,End User
37 5.6 Fix period 6 days Tue 9/10/19Tue 9/17/1936 $10,224.00 Agile Team
38 5.7 Deploy 1 day Wed 9/18/19Wed 9/18/1937 $560.00 Scrum Master
End User,Project Owner,Scrum Master
Agile Team
Agile Team
Agile Team,End User
Agile Team
Scrum Master
End User,Project Owner,Scrum Master
Agile Team
Agile Team
Agile Team,End User
Agile Team
Scrum Master
End User,Project Owner,Scrum Master
Agile Team
Agile Team
Agile Team
Agile Team,End User
Agile Team
Scrum Master
End User,Project Owner,Scrum Master
Agile Team
Agile Team
Agile Team
Agile Team,End User
Agile Team
Scrum Master
End User,Project Owner,Scrum Master
Agile Team
Agile Team
Agile Team
Agile Team,End User
Agile Team
Scrum Master
W S T M F T
Apr 7, '19 Jun 2, '19 Jul 28, '19 Sep 22, '19
Figure 8: Gantt Chart of Wenty Library System Development Project
(Source: Created by Author)

16SYSTEM ANALYSIS AND DESIGN
Bibliography:
Haupt, Melanie, Carl Vadenbo, and Stefanie Hellweg. "Do we have the right performance
indicators for the circular economy?: insight into the Swiss waste management system." Journal
of Industrial Ecology 21, no. 3 (2017): 615-627.
Karplus, Susan S. "Integrating academic library resources and learning management systems:
The library Blackboard site." Education Libraries 29, no. 1 (2017): 5-11.
Laudon, Kenneth C., and Jane P. Laudon. Management information system. Pearson Education
India, 2016.
Moran, Barbara B., and Claudia J. Morner. Library and information center management. ABC-
CLIO, 2017.
Prytherch, Ray. Harrod's librarians' glossary and reference book: a directory of over 10,200
terms, organizations, projects and acronyms in the areas of information management, library
science, publishing and archive management. Routledge, 2016.
Videnovic, Aleksandar. "Management of sleep disorders in Parkinson's disease and multiple
system atrophy." Movement Disorders 32, no. 5 (2017): 659-668.