digital library system
TRANSCRIPT
2
This project aims to develop a data based desktop
application.
It has provisions for
◦ Users to search and preview books
◦ Know availability of books
◦ Request for new books
◦ View their recordsDIGITAL LIBRARY SYSTEM
ABSTRACT
4DIGITAL LIBRARY SYSTEM
Administrator has the authority to:
Add new entries, delete existing entries
and edit the contents of members, books
and issue log data table.
View Requested Books and delete
Requested books.
5DIGITAL LIBRARY SYSTEM
User can do the following• Query the Books data table to search for books and
preview their contents.
• Query the issue log and members table to know
availability of books and view their records.
• Add new entries to Requested Books table.
6
Manual.
Drawbacks : Users have to browse the library manually to know
availability of required books and content. It is time consuming. No provision for the users to request new books or add
complaints. Users have to query the librarian for details of fine and
books.
DIGITAL LIBRARY SYSTEM
EXISTING SYSTEM
7
The proposed systems aims to: Enhance interaction with users. Reduce time and effort required to find required books. Improve efficiency and quality of service. Make more books available for borrow in the long term
by completely digitalizing the reference section.
DIGITAL LIBRARY SYSTEM
PROPOSED SYSTEM
8
1.SOFTWARE REQUIREMENTS
Operating system : Windows 8.1
Data Base : SQLite
Programming Language : Java
IDE : Eclipse Mars
IGITAL LIBRARY SYSTEM
DEVELOPMENT ENVIRONMENT
9
2.HARDWARE REQUIREMENTS Processor :Intel core i5 Memory size : 4 GB of RAM Input : Mouse/Keyboard/touch
DIGITAL LIBRARY SYSTEM
10
Graphical representation of the system in the context level.
DIGITAL LIBRARY SYSTEM
DATA FLOW DIAGRAM
USER/ADMINIST
RATOR DIGITAL LIBRARY SYSTEM
USER/ADMINISTRAT
ORrequest reply
DIGITAL LIBRARY SYSTEM 11
ADMINISTRATOR Login
add, edit, view,delete
view, delete
Add,Edit, view, delete
Add, edit, view,
delete
Books Members
Requested Books
Issue Log
ADMINISTRATOR
DIGITAL LIBRARY SYSTEM 12
USER Login
View
Search
Requested BooksBooks
Issue Log
Add,view
USER
View
Members
DIGITAL LIBRARY SYSTEM 13
There are 4 tables used. Books
Field Data Type Default KeyBook_id INT NOT NULL PKB_Name VARCHAR NULLAuthor VARCHAR NULL
Publication VARCHAR NULL
Cost FLOAT NULL
Subject VARCHAR NULL
CONTENT BLOB NULL
TABLES
DIGITAL LIBRARY SYSTEM 14
FIELD DATA TYPE DEFAULT KEY
Id_no INT NOT NULL PKName VARCHAR NULLClass VARCHAR NULL
Date of Join DATETIME NULLDate of expiry DATETIME NULL
MEMBERS
REQUESTED BOOKSFIELD DATA TYPE DEFAULT KEYBookTitle VARCHAR NOT NULL PKRequestedBy VARCHAR NOT NULL PK
Author VARCHAR NULL
Subject VARCHAR NULL
DIGITAL LIBRARY SYSTEM 15
ISSUE LOGFIELD DATA TYPE DEFAULT KEYBook_id INT NOT NULL PKId_no INT NOT NULL FKIssue_date DATETIME NULLDue_date DATETIME NULL
DIGITAL LIBRARY SYSTEM 16
In the long term, this project will make the use of library more efficient and effective.
It’s a real improvement over the existing manual system.
In the future, this application can be extended to include a management system thus integrating all library related applications into one system.
CONCLUSION