// ACADEMIC CONTENT PORTAL · Computer Science

Thesis Topic Ideas: Library Management System (NEB +2 Practical)

Level: +2Difficulty: Beginner★ Popular Choice

Applicable Universities:Tribhuvan University (TU)Kathmandu University (KU)Pokhara University (PU)

🎓 Academic Journey Progression Map

Grade 8-10 (SEE)
School Projects
+2 (Grades 11-12)
Stream Projects
Bachelor's Degree
Undergraduate Thesis
Master's Degree
Postgraduate Thesis
PhD Doctorate
Dissertation Guidance

✓ Why This Topic Works (Student & Parent Reassurance)

Why this topic works for +2 Computer Science: Aligns directly with NEB Grade 12 Computer Science syllabus (Database Management Systems and Python programming), delivering a complete functional project for practical exams.

1. Introduction & Problem Statement

Overview: A Python and MySQL desktop application designed for NEB Grade 11-12 Computer Science practical portfolios, featuring book issue/return, fine calculation, and overdue alerts.

Background Context (Nepal): Grade 12 Computer Science under the National Examinations Board (NEB) requires students to submit a practical database-driven software application. Building a Library Management System reinforces SQL queries and Python GUI/CLI integration.

2. Research Objectives

›Design normalized MySQL relational database schema (Books, Members, Transactions)
›Implement Python script with MySQL connector for CRUD operations (Add, Issue, Return, Search)
›Automate overdue fine calculation (e.g. NPR 5/day after 14 days loan period)
›Generate student borrowing history and overdue book reports
›Create clean user interface (Tkinter GUI or structured CLI menu)

3. Proposed Methodology

Requirement analysis based on typical school/college library workflow
Database design using Entity-Relationship (ER) modeling in MySQL
Python programming using `mysql-connector-python` or `sqlite3` libraries
Testing edge cases (invalid book ID, returning non-issued books, calculating accumulated fines)
Documenting source code, ER diagrams, and sample database screenshots for NEB board evaluation

$ Worked Example / Sample Scenario

Sample Scenario: A Class 12 student enters Member ID #104 and Book ID #202. The Python script verifies book availability, registers the issue date, and displays due date in 14 days, satisfying NEB external practical exam requirements.

4. Thesis Chapter-by-Chapter Outline

Chapter 1: Introduction & System RequirementsTU/KU/NEB standard

Project background, NEB practical guidelines, and functional requirements

Chapter 2: Database Design & ER DiagramTU/KU/NEB standard

Entity relationships, table schemas, primary/foreign keys, and SQL DDL scripts

Chapter 3: Python Source Code ImplementationTU/KU/NEB standard

Annotated code explaining database connections, query execution, and UI modules

Chapter 4: Testing & Screen OutputTU/KU/NEB standard

Sample test execution screenshots covering issue, return, and fine computation

Chapter 5: Conclusion & Portfolio SummaryTU/KU/NEB standard

Learning outcomes and future enhancement roadmap (barcode reader integration)

5. Recommended Tools & Technologies

To implement the practical, technical, or analytical portions of this thesis topic, the following software tools, libraries, or APIs are recommended:

Python 3MySQL / SQLiteTkinterVS Code

6. Core References & Academic Sources

[1]NEB Grade 12 Computer Science Practical Curriculum Manual
[2]Python MySQL Connector Official Documentation (dev.mysql.com)
[3]CDC Nepal Class 12 Computer Science Textbook

7. Frequently Asked Questions (FAQs)

Q: Can I use SQLite instead of MySQL for NEB practical exams?

Yes, both SQLite and MySQL are approved for NEB Grade 12 practical project portfolios.

Q: Is a graphical GUI compulsory or is CLI accepted?

A CLI menu is fully accepted by NEB external examiners, though adding Tkinter GUI earns extra distinction.

Q: How does the fine calculation logic work?

Subtract issue date from return date; if days > 14, multiply extra days by daily fine rate (e.g. NPR 5).

Q: Can this project be expanded for Bachelor BCA/BSc CSIT?

Yes, Bachelor level expansions add web-based Next.js UI, user authentication, and barcode scanner integration.