11600682-library-management-system.doc 2i454q
This document was ed by and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this report form. Report r6l17
Overview 4q3b3c
& View 11600682-library-management-system.doc as PDF for free.
More details 26j3b
- Words: 1,571
- Pages: 30
N.E.D. University of Engineering & Technology Computer Science & Information Technology
Library Management System LMS Project Owner:Rabia Khalid –SCIT (104) Hameeda Naz –SCIT (103) Quratulain –SCIT (118) Submitted to: Sir Abdul Khalique Shaikh
Table of Content
S.No
Content
Page #
01
Acknowledgement
03
02
Scope definition
04
03
Project description
04
04
Sequence diagram
06
05
Use case diagram for student
07
06
Use case diagram for Professor
08
07
Use case diagram for Librarian
09
08
Data flow diagram
10
09
Entity relationship diagram
11
10
Tables of library management system
12
11
Screen shots
15
2
12
Stored procedure
28
13
Time spends
29
14
References
30
ACKNOWLEDGEMENT: We are very thankful to our database teacher who assigns us this project so that we can utilize our skills. While working on this project we have received suggestion from our senior Mirza Sohail Hussain, who really help us in solving different problems and suggest how we overcome limitations.
3
LIBRARY MANAGEMENT SYSTEM SCOPE DEFINITION: The Library Management System is designed for managing various activities of “Central University Library”. Since library has a very large number of books and a large number of , it is impossible for librarian to manage day to day activities manually. It keep track of following information. 1. Books in Library. 2. Categories of books. 3. Books that are requested by the . 4. Books that are issued to . 5. Books that are not allowed to issue. 6. Detail of who issued the books. The Library Management System has following s. 1. Librarian 2. students 3. Professors
PROJECT DESCRIPTION: Member and librarian can to the system using screen. After there are several tasks that can be performing, if librarian is then he can do following tasks.
4
1. Member Management: Librarian can search either by there name or by ID. He can update information about , view and create new . 2. Manage book categories: In this librarian can manage books category. He can add, update and view books. 3. Lend books: When member request the books then librarian lend a particular book. If all the available books are lend out to , and then librarian can not approve the request until some return the books. A catalog of books is available online that lists books by author, title and subject area. Student member can check out books for a month. 4. View reports: Librarian can view the report to know which hip are about to expire, so that he sent renewal notice to particular . He can check how many books are in issued. 5. Change : Both librarian and can change their . If member is then he can request a book, check books that are available and then request for particular book. Member can return a book, can change and can view the reports. are allowed to have only three books out at a time if student, and five books if professor.
5
SEQUENCE DIAGRAM:
6
7
8
9
DATA FLOW DIAGRAM:
10
ERD Of Library Management System:
11
TABLES OF LIBRARY MANAGEMENT SYSTEM: 1. Librarian: This table holds the information of librarian.
Attributes: 1. Lib_id (librarian id) 2. lib_name (librarian name)
2. Lib- : In this table librarian in to system.
Attributes: 1. lib_id (librarian id) 2. id. 3. .
3. Issuance detail: This table holds the information about books issuance.
Attributes: 1. Issue_ id (issuance id) 2. Book id.
4. Member: In this table personal information of member is present.
Attributes: 1. 2. 3. 4. 5. 6.
mem_id(member id) Name. Phone #. Type (student/professor) mem since (member since) Exp date (expiry date ) 12
7. Per add (permanent address) 8. Local add (local address)
5. Member : In this table member detail is stored.
Attributes: 1. 2. 3. 4.
Mem id (member id) id. . Type (student/professor)
6. Issuance: This table holds the information about book issuance.
Attributes: 1. 2. 3. 4. 5.
issue date. ret date (return date) Status. Iss_id (issuance id) Mem id (member id)
7. Books: This table holds the information about books.
Attributes: 1. 2. 3. 4. 5. 6. 7.
Title. ISBN (primary key) Edition. Cat id (category id) Desc (description) Type. Author.
8. Category: 13
This table holds the information about the categories of books.
Attributes: 1. 2. 3. 4.
Cat id (category id) Cat name (category name) # books (no. of books) Desc (description)
9. Receiving Detail: This table holds the information of who have received the books.
Attributes: 1. 2. 3. 4.
Book id. Rec id(receiving id) Rupees. Fine.
10.Receiving Master: This table holds the information of who have issued the books.
Attributes: 1. Rec_id (receiving id) 2. Issue_id (issuance id) 3. Return date.
SCREEN STOHS: 14
First of all there is screen in which if is Librarian then he click on librarian button and if is Member then he clicks on member button.
When librarian is selected the librarian should be able to to the system using screen.
15
After a librarian to the system, he should be able to perform the following tasks.
A librarian should be redirected to the form Member management when he clicks on Member Management form. Initially all the are displayed when the form is loaded. He can search the 16
member by name or by ID. When member name or member ID is put in search field and “Search” button is clicked, only who satisfy the search criteria appears in the data grid view. Librarian can also view member detail when he clicks button ‘View member detail’.
17
Librarian can update the information by clicking button “Update Information”.
18
When in Member Management form librarian wants to add new he click on the button Create new member and he is redirected to form “Create Member”. When the valid information is entered and ‘create’ button is clicked a new is created in the system.
Librarian is redirected to Librarian Task form when he clicks on button ‘Return to main menu’.
19
On the Librarian task form when librarian clicks on “Manage Book Categories” form he is redirected to “Manage book categories” form where he can manage the books.
When the form is loaded all available book categories is displayed. When librarian select the particular category librarian can manage or update books to that category.
In the “Add book Category” region, the librarian can insert a new category to the system. 20
When librarian clicks on “Manage books” he is redirected to form where he can edit/search/add book information in to the system.
21
In this form librarian can search book of particular category that was selected in “Manage book Category” form. He can search books by their title, ISBN or author. When the search button is clicked only the books in current category are selected. And when the “Search all categories” is clicked, books in all categories are searched based on provided search criteria. In the “Add Book to Current Category” region librarian can add books. 22
When librarian clicks on “Edit Selected Book” button he is redirected to form where he can change all the information about that book except its ISBN number and parent Book Category ID.
23
When librarian click on “update book category” button in “Manage Book Categories” form, he can update the selected book category information.
24
Both librarian and member can change there by clicking the “Change ” button on main menu .
A member can to the system using similar interface as that of librarian .
25
When a member (student or professor) logs in into the system he can perform following tasks.
When member click on request button, he is redirected to Member Request Form where by selecting a category he can request for book.
26
Librarian can lend books when member request for particular book.
27
STORED PROCEDURE: In the back end there are 2 stored procedures. The function of each stored procedure is give below. 1. sp_find_request: This is used for showing the data of who have made a request for books. 2. sp_cat_view: This is used for showing the data in the category table.
28
TIME SPENDS: Serial #
Date
Work done
Time Hours
Group
1
9-6-08
Analysis
2-hours
2.
11-6-08
ERD
3-hours
3.
14-6-08
Normalization
2-hour
4.
16-6-08
Data base
1-hour
5.
16-6-08
Table formation
2-hours
6.
21-6-08
Form deg and 2 forms manipulation 1-hour
All are present
7-
23-6-08
Forms
Rabia Khalid
8
26-6-08
Forms
9
29-6-08
Forms
10
1-07-08
Forms
11
8-07-08
Forms
12
12-7-08
Forms
13
1-9-08
Forms
14
2-9-08
Forms
15
`3-9-08
Forms
16
4-9-08
Forms presentation
29
1 form ½ hour 3 forms 2-hours 2 form 1-hour 2 forms 1-hour 2 form 1-hour 2 form 2-hour 1 form 1 hour 1 form 1hour 1 form ½ hour 1 hour
All group are present All group All group All group Rabia khalid
All group All group All group All group All group All group All group All group Rabia Khalid
REFERENCE: Reference for “Library Management System” is taken from project proposal having description which was given by our teacher “Sir Abdul Khalique Shaikh”.
IDS: 1. [email protected] (Hameeda naz-103)
30
Library Management System LMS Project Owner:Rabia Khalid –SCIT (104) Hameeda Naz –SCIT (103) Quratulain –SCIT (118) Submitted to: Sir Abdul Khalique Shaikh
Table of Content
S.No
Content
Page #
01
Acknowledgement
03
02
Scope definition
04
03
Project description
04
04
Sequence diagram
06
05
Use case diagram for student
07
06
Use case diagram for Professor
08
07
Use case diagram for Librarian
09
08
Data flow diagram
10
09
Entity relationship diagram
11
10
Tables of library management system
12
11
Screen shots
15
2
12
Stored procedure
28
13
Time spends
29
14
References
30
ACKNOWLEDGEMENT: We are very thankful to our database teacher who assigns us this project so that we can utilize our skills. While working on this project we have received suggestion from our senior Mirza Sohail Hussain, who really help us in solving different problems and suggest how we overcome limitations.
3
LIBRARY MANAGEMENT SYSTEM SCOPE DEFINITION: The Library Management System is designed for managing various activities of “Central University Library”. Since library has a very large number of books and a large number of , it is impossible for librarian to manage day to day activities manually. It keep track of following information. 1. Books in Library. 2. Categories of books. 3. Books that are requested by the . 4. Books that are issued to . 5. Books that are not allowed to issue. 6. Detail of who issued the books. The Library Management System has following s. 1. Librarian 2. students 3. Professors
PROJECT DESCRIPTION: Member and librarian can to the system using screen. After there are several tasks that can be performing, if librarian is then he can do following tasks.
4
1. Member Management: Librarian can search either by there name or by ID. He can update information about , view and create new . 2. Manage book categories: In this librarian can manage books category. He can add, update and view books. 3. Lend books: When member request the books then librarian lend a particular book. If all the available books are lend out to , and then librarian can not approve the request until some return the books. A catalog of books is available online that lists books by author, title and subject area. Student member can check out books for a month. 4. View reports: Librarian can view the report to know which hip are about to expire, so that he sent renewal notice to particular . He can check how many books are in issued. 5. Change : Both librarian and can change their . If member is then he can request a book, check books that are available and then request for particular book. Member can return a book, can change and can view the reports. are allowed to have only three books out at a time if student, and five books if professor.
5
SEQUENCE DIAGRAM:
6
7
8
9
DATA FLOW DIAGRAM:
10
ERD Of Library Management System:
11
TABLES OF LIBRARY MANAGEMENT SYSTEM: 1. Librarian: This table holds the information of librarian.
Attributes: 1. Lib_id (librarian id) 2. lib_name (librarian name)
2. Lib- : In this table librarian in to system.
Attributes: 1. lib_id (librarian id) 2. id. 3. .
3. Issuance detail: This table holds the information about books issuance.
Attributes: 1. Issue_ id (issuance id) 2. Book id.
4. Member: In this table personal information of member is present.
Attributes: 1. 2. 3. 4. 5. 6.
mem_id(member id) Name. Phone #. Type (student/professor) mem since (member since) Exp date (expiry date ) 12
7. Per add (permanent address) 8. Local add (local address)
5. Member : In this table member detail is stored.
Attributes: 1. 2. 3. 4.
Mem id (member id) id. . Type (student/professor)
6. Issuance: This table holds the information about book issuance.
Attributes: 1. 2. 3. 4. 5.
issue date. ret date (return date) Status. Iss_id (issuance id) Mem id (member id)
7. Books: This table holds the information about books.
Attributes: 1. 2. 3. 4. 5. 6. 7.
Title. ISBN (primary key) Edition. Cat id (category id) Desc (description) Type. Author.
8. Category: 13
This table holds the information about the categories of books.
Attributes: 1. 2. 3. 4.
Cat id (category id) Cat name (category name) # books (no. of books) Desc (description)
9. Receiving Detail: This table holds the information of who have received the books.
Attributes: 1. 2. 3. 4.
Book id. Rec id(receiving id) Rupees. Fine.
10.Receiving Master: This table holds the information of who have issued the books.
Attributes: 1. Rec_id (receiving id) 2. Issue_id (issuance id) 3. Return date.
SCREEN STOHS: 14
First of all there is screen in which if is Librarian then he click on librarian button and if is Member then he clicks on member button.
When librarian is selected the librarian should be able to to the system using screen.
15
After a librarian to the system, he should be able to perform the following tasks.
A librarian should be redirected to the form Member management when he clicks on Member Management form. Initially all the are displayed when the form is loaded. He can search the 16
member by name or by ID. When member name or member ID is put in search field and “Search” button is clicked, only who satisfy the search criteria appears in the data grid view. Librarian can also view member detail when he clicks button ‘View member detail’.
17
Librarian can update the information by clicking button “Update Information”.
18
When in Member Management form librarian wants to add new he click on the button Create new member and he is redirected to form “Create Member”. When the valid information is entered and ‘create’ button is clicked a new is created in the system.
Librarian is redirected to Librarian Task form when he clicks on button ‘Return to main menu’.
19
On the Librarian task form when librarian clicks on “Manage Book Categories” form he is redirected to “Manage book categories” form where he can manage the books.
When the form is loaded all available book categories is displayed. When librarian select the particular category librarian can manage or update books to that category.
In the “Add book Category” region, the librarian can insert a new category to the system. 20
When librarian clicks on “Manage books” he is redirected to form where he can edit/search/add book information in to the system.
21
In this form librarian can search book of particular category that was selected in “Manage book Category” form. He can search books by their title, ISBN or author. When the search button is clicked only the books in current category are selected. And when the “Search all categories” is clicked, books in all categories are searched based on provided search criteria. In the “Add Book to Current Category” region librarian can add books. 22
When librarian clicks on “Edit Selected Book” button he is redirected to form where he can change all the information about that book except its ISBN number and parent Book Category ID.
23
When librarian click on “update book category” button in “Manage Book Categories” form, he can update the selected book category information.
24
Both librarian and member can change there by clicking the “Change ” button on main menu .
A member can to the system using similar interface as that of librarian .
25
When a member (student or professor) logs in into the system he can perform following tasks.
When member click on request button, he is redirected to Member Request Form where by selecting a category he can request for book.
26
Librarian can lend books when member request for particular book.
27
STORED PROCEDURE: In the back end there are 2 stored procedures. The function of each stored procedure is give below. 1. sp_find_request: This is used for showing the data of who have made a request for books. 2. sp_cat_view: This is used for showing the data in the category table.
28
TIME SPENDS: Serial #
Date
Work done
Time Hours
Group
1
9-6-08
Analysis
2-hours
2.
11-6-08
ERD
3-hours
3.
14-6-08
Normalization
2-hour
4.
16-6-08
Data base
1-hour
5.
16-6-08
Table formation
2-hours
6.
21-6-08
Form deg and 2 forms manipulation 1-hour
All are present
7-
23-6-08
Forms
Rabia Khalid
8
26-6-08
Forms
9
29-6-08
Forms
10
1-07-08
Forms
11
8-07-08
Forms
12
12-7-08
Forms
13
1-9-08
Forms
14
2-9-08
Forms
15
`3-9-08
Forms
16
4-9-08
Forms presentation
29
1 form ½ hour 3 forms 2-hours 2 form 1-hour 2 forms 1-hour 2 form 1-hour 2 form 2-hour 1 form 1 hour 1 form 1hour 1 form ½ hour 1 hour
All group are present All group All group All group Rabia khalid
All group All group All group All group All group All group All group All group Rabia Khalid
REFERENCE: Reference for “Library Management System” is taken from project proposal having description which was given by our teacher “Sir Abdul Khalique Shaikh”.
IDS: 1. [email protected] (Hameeda naz-103)
30
More Documents from "tamirat" 1t62j
11600682-library-management-system.doc 2i454q
January 2022 0
Huawei Ascend Y300 Firmware Upgrade s6f51
November 2019 113
Basic Calculator Tutorial In Visual Basic 2h5q2m
October 2019 75
52817427-library-management-system.pdf 3276f
October 2019 49
Product Key c1y50
October 2019 95