Scribd
Upload
4 views4 pages

Library Management System with DBMS

The document outlines a summer internship project titled 'Library Management System Using DBMS' completed by Ankit Sharma at TechSolutions Pvt. Ltd. under the guidance of Prof. Priya Mehra. It details the transition from a manual library system to a centralized DBMS-driven application, including system design, implementation using Python and MySQL, and testing results. The project aims to enhance library operations and suggests future enhancements like RFID tracking and SMS reminders.

Uploaded by

himanshubaghel14afs
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
4 views4 pages

Library Management System with DBMS

The document outlines a summer internship project titled 'Library Management System Using DBMS' completed by Ankit Sharma at TechSolutions Pvt. Ltd. under the guidance of Prof. Priya Mehra. It details the transition from a manual library system to a centralized DBMS-driven application, including system design, implementation using Python and MySQL, and testing results. The project aims to enhance library operations and suggests future enhancements like RFID tracking and SMS reminders.

Uploaded by

himanshubaghel14afs
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Python

Project Title: Library Using DBMS

Student Name: kumar

Roll Number: MCA/247

College Name: Sunrise Institute of Technology

Internship Organization: iey

Guide Name: Prof. arun

Submission Date: April 2027

Declaration
I, Ankit Sharma, hereby declare that the summer internship project titled 'Library Management
System Using DBMS' is a result of my own work carried out at TechSolutions Pvt. Ltd., under the
guidance of Prof. Priya Mehra, in partial fulfillment of the requirements for the degree of Master of
Computer Applications from Sunrise Institute of Technology.

Certificate
This is to certify that Mr. Ankit Sharma, Roll No. MCA/2023/045, has successfully completed his
summer internship project titled 'Library Management System Using DBMS' at TechSolutions Pvt.
Ltd. during May-July 2024 under my supervision.

Acknowledgment
I express my sincere gratitude to my project guide Prof. Priya Mehra for her invaluable support. I
also thank TechSolutions Pvt. Ltd. for providing me the opportunity and infrastructure to complete
this internship.

Table of Contents
1. Introduction

2. Company Profile

3. System Study

4. System Design

5. Implementation

6. Testing

7. Result and Analysis

8. Conclusion and Future Scope

9. References

10. Appendix

3. System Study
Existing System:
Manual book entries, handwritten borrow records, and no alert system for due dates.

Proposed System:
A centralized DBMS-driven application for managing all library operations digitally.

Feasibility:
- Technical: Easily implemented using MySQL and Python.
- Operational: Reduces human errors and workload.
- Economic: Cost-effective and scalable for future needs.
4. System Design
- ER Diagram includes entities like Books, Students, Librarians, Issue, Return.
- Data Flow Diagram (DFD) represents data movement between modules.

5. Implementation
- Front-End: Python (Tkinter)
- Back-End: MySQL
- Modules:
- Book Management
- Student Registration
- Issue/Return System
- Fine Calculation

6. Testing
- Unit Testing: Verified individual modules.
- Integration Testing: Checked data flow between front-end and database.

- Adding a new book → PASS


- Test Cases:

- Issuing a book to unregistered student → FAIL

8. Conclusion and Future Scope


The system streamlined library operations and can be expanded to include RFID-based tracking,
SMS reminders, and a web interface.

9. References
- MySQL Documentation
- Python Tkinter Guide
- IEEE Research on Library Systems

10. Appendix
- Screenshots of GUI
- Sample SQL Queries

You might also like