Hanoi-Aptech Computer Education
Group 1
Library Management System
Documentation
Group 1
Group Member
VN.015/200803/5324 V c H
VN.015/200707/4752 Lu Tun Anh
VN.015/200803/5561 Anh c
Instructor
Phung Anh Tan
- Hanoi, 10/2009 -
Library Management System
Page 1 of 19
Hanoi-Aptech Computer Education
Group 1
INDEX
1.
Problem Definition..........................................................................................................3
1.1.
Problem Abstraction................................................................................................3
1.2.
The Current System.................................................................................................3
1.3.
The Proposed System...............................................................................................3
1.4.
Boundaries of the System........................................................................................3
1.5.
Hardware and Software Requirements....................................................................3
1.5.1.
Minimum Requirements..................................................................................3
1.5.2.
Recommended Requirements..........................................................................3
2. Customer Requirements Specification.............................................................................4
2.1.
Users of the System.................................................................................................4
2.2.
System functions......................................................................................................4
3. Architecture and Design of Project..................................................................................5
3.1.
Data Flow Diagram..................................................................................................5
3.2.
Entity Relationship Diagram(Table Design)............................................................5
3.3.
Database Structure...................................................................................................5
3.4.
Screen Design..........................................................................................................5
4. Task Sheet........................................................................................................................6
5. Checklists.........................................................................................................................7
5.1.
Check List of Validation..........................................................................................7
5.2.
Submission Checklist...............................................................................................7
Library Management System
Page 2 of 19
Hanoi-Aptech Computer Education
1.
1.1.
Group 1
Problem Definition
Problem Abstraction
To day, business manages system to require the effect and to economize time
.First and foremost in business manages library book of a company .Therefore we
present sofware to manage library book of the Mohan Ltd company.
1.2.
The Current System
Mohan Ltd. has a library which is managed by Ms. Monica manually. All
records are on paper and Monica finds it very difficult to manage when somebody
issues or returns the books. She has to maintain list of books along with details such
as Author name, book title etc. When a book is to be issued, she has to manually
search for that book and again for issuing book she has to maintain a register which
will have details of book issued such as Name of the book, Author, Employee details
(name, department etc) , Date of issue, Date of return, etc. This process is tedious
and time consuming. She has brought it to the notice of her seniors and they have
proposed the solution of developing a system which will help Monica managing the
things more effectively and also save her time. She will be the only user of the
system.
1.3.
The Proposed System
- Software Library Management Book of we will help to Ms. Monica, can
manage book have library same manage business borrow and return book.
1.4.
Boundaries of the System
Boundaries of system will built:
- Software Library Management Book of we, have size small only use to a
company.
1.5.
Hardware and Software Requirements
1.5.1. Minimum Requirements
Minimum
PC Pentium II 600 MHz
128MB RAM
500 MB hard drive
1.5.2. Recommended Requirements
Preferred
PC Pentium III 1800 MHz
Library Management System
Page 3 of 19
Hanoi-Aptech Computer Education
Group 1
2G RAM
2 GB hard drive
1.5.3. Software
Software:
-JDK 1.6
-Netbean 6.1
-Sql server 2005
2. Customer Requirements Specification
1.6.
Users of the System
The object influence system include:
-
User
1.7. System functions
Function User
1. Add, edit Employee
Description
User add, edit employee.
Input
-Employee ID.
-Name.
-Address.
-Phone Number.
-Department.
-EmployStatus.
Process
Update data in database when add, edit employee.
Output
Display employee edit v employee new.
Library Management System
Page 4 of 19
Hanoi-Aptech Computer Education
Group 1
2. Delete Employee
Description
User delete employee.
Input
-Employee ID.
Process
Update data in database when delete employee.
Output
Display announcement you deleted successful.
3. Add, edit Book
Description
User add, edit book.
Input
-Book ID.
-CallNumber(XX-XX-XXX)
-ISBN.(XXX-XXXX)
-Title.
-Phone Number.
-PubHouse.
Process
Update data in database when add, edit book.
Output
Display book edit v book new.
4. Delete Book
Description
User delete book.
Input
-Book ID.
Process
Update data in database when delete book.
Output
Display announcement you deleted successful.
Library Management System
Page 5 of 19
Hanoi-Aptech Computer Education
Group 1
5. Add, edit, delete User
Description
User add, edit, delete user.
Input
-User ID.
-Name.
-User Status.
Process
Update data in database when add, edit, delete user.
Output
Display user edit v user new.
6. Search Book
Description
User search book.
Input
-Call number.(XX-XX-XXX)
-ISBN number.(XXX-XXXX)
-Title.
-Author
Process
Access data from database and to take information book satisfy require search.
Output
-If have book then display information book where User search.
-If not have book then display announcement
7. Check Out
Description
User give Employee borrow book ,search book.
Input
-Call number.
-ISBN number.
-Title.
-Author.
-Employee ID
Process
Output
Update data in database when librarian add the ballok give borrow book.
-Display result the ballok borrow book.
Library Management System
Page 6 of 19
Hanoi-Aptech Computer Education
Group 1
8. Check In
Description
User agree the book return from Employee, search Employee Name.
Input
-Date borrow.
-Date due.
-Employee Name.
Process
Output
Access data from database and to take information the ballok give borrow book,
compare the due date and return date if The Employee keep a borrowed book in
excess of the time limit then Employee was punish 10 cent each day.
-Display result the ballok give the book return.
9. Display information detail book
Description
Input
Function give the librarian see the book detail.
Process
Output
To take the information book from database.
-Display the information require.
-Choose the book need see.
10. Display information detail employee
Description
Function give the librarian see the book detail.
Input
-Choose the Employee need see.
Process
Output
To take the information book from database.
-Display the information require.
[Link] in
Description
To allow the librarian log in.
Input
-UserName and Password.
Process
Check UserName and Password in database.
Output
-Display the result log in.
Library Management System
Page 7 of 19
Hanoi-Aptech Computer Education
Group 1
[Link] out
Description
To allow the librarian log out.
Input
- UserName and Password.
Process
Check UserName and Password in database.
Output
-Display the result log out.
3. Architecture & Design of Project
3.1.
Data Flow Diagram
Level 0:
Level 1:
Library Management System
Page 8 of 19
Hanoi-Aptech Computer Education
Group 1
Level 2:
Library Management System
Page 9 of 19
Hanoi-Aptech Computer Education
Library Management System
Group 1
Page 10 of 19
Hanoi-Aptech Computer Education
Group 1
Level 3:
Library Management System
Page 11 of 19
Hanoi-Aptech Computer Education
Library Management System
Group 1
Page 12 of 19
Hanoi-Aptech Computer Education
Group 1
3.2.
Entity Relationship Diagram (Table Design)
3.3.
Database Structure
3.3.1. Borrow
Fields
Type
BorrowId
int
StartDate
Size
4
Constraint
Description
Primay key, identity(1,1)
Code ballok book borrow
datetime
Default getdate()
Day book borrow
DueDate
datetime
Default getdate()
Day appoint book return
RealDate
datetime
Default getdate()
Day book return
File
int
check>=0
Number money punish
BorrowStatus
bit
Default 0
Status ballok
EmployeeID
int
Foreign key, not null
Code Employee
3.3.2. Book
Fields
Type
Size
Constraint
BookId
int
Primay key, identity(1,1)
CallNumber
varchar
50
Not null
ISBN
varchar
50
Not null
Library Management System
Description
Code book
Page 13 of 19
Hanoi-Aptech Computer Education
Title
nvarchar
NumOfCopies
int
NameAuthor
varchar
PublishHouse
varchar
NumOfContinue int
100
50
50
Group 1
Not null
Title of book
check>=0
Number book copies
not null
not null
check>=0
Name author
Name Publish House
Number book continue
[Link]
Fields
Type
Size
BorrowID
int
BookID
int
Constraint
Primay key, identity(1,1), Foreign
key, not null
Primay key, identity(1,1), Foreign
key, not null
Description
Code ballok book borrow
Code book
[Link]:
Fields
Type
Size
Constraint
Description
EmployeeId
int
Primay key, identity(1,1)
Code Employee
Name
nvarchar
50
Not null
Name Employee
Address
varchar
50
Not null
Address Employee
PhoneNumber
varchar
50
Not null
Phone Employee
Department
nvarchar
50
check>=0
Gender
bit
Department company
Store gender of user
If = 0 : Female
If = 1 : Male
Default 0
[Link]
Field Name
U_ID
Int
Data Type
Null Key
No
PK
Store ID of user
Description
U_Name
Varchar(30)
No
Store name of user
UserName
Password
Email
BirthDate
Gender
Varchar(30)
Varchar(32)
Varchar(50)
Datetime
Bit
No
No
Yes
Yes
Yes
Phone
Varchar(20)
Yes
Store username of user
Store password of user
Store email of user
Store user s birthday
Store gender of user
If = 0 : Female
If = 1 : Male
Store phone of user
[Link]
Library Management System
Page 14 of 19
Hanoi-Aptech Computer Education
Fields
Type
SubjectID
int
SubjectName
nvarchar
3.4.
Group 1
Size
4
450
Constraint
Description
Primay key, not null
Store code subject
not null
Store name subject
Screen Design
Login
Home
Library Management System
Page 15 of 19
Hanoi-Aptech Computer Education
Group 1
USER MANAGER
EMPLOYEE MANAGER
Library Management System
Page 16 of 19
Hanoi-Aptech Computer Education
Group 1
BOOK MANAGER
BORROW MANAGER
Library Management System
Page 17 of 19
Hanoi-Aptech Computer Education
Group 1
[Link] Sheet
Project Ref. No.:
Sr.
No
.
Project
title
Task
Activity
Plan
Prepared
by :
Date of Preparation of Activity Plan :
Actual
Start
Date
Actual Team
Days
Member
Names
Status
[Link]
1
Problem Definition
Library
Manager
System
- Vu Duc Ha
- Do Anh Duc
Completed
Customer
Requirements
Specification
Library
Manager
System
Completed
DFD
Library
Manager
System
ERD, Table Design
Library
Manager
System
- Vu Duc Ha
- Do Anh Duc
-Luu Tuan
Anh
- Vu Duc Ha
- Do Anh Duc
-Luu Tuan
Anh
Vu Duc Ha
Library
Manager
System
Library
Manager
System
Library
Manager
System
Vu Duc Ha
Completed
Do Anh Duc
Complete
Completed
Completed
[Link]
Login
User Manager
Employee
Manager
Change Personal
Information
Library
Manager
System
Vu Duc Ha
Completed
Borrow Manager
Library
Manager
System
Vu Duc Ha
Completed
Library Management System
Luu Tuan Anh Completed
Page 18 of 19
Hanoi-Aptech Computer Education
Group 1
Search
Library
Manager
System
Vu Duc Ha
Completed
Change Password
Library
Manager
System
Do Anh Duc
Completed
Book Manager
Library
Manager
System
Vu Duc Ha
Completed
5. Checklists
Option
Do all the options present in the application display the correct result?
Dose the applications functionality resolve the user problem, and satisfy their
needs?
Has the hardware and software been correctly chosen?
Library Management System
Validated
Yes
Yes
Yes
Page 19 of 19