Assessfy Pvt. Ltd Beginner 5 milestones 100 marks

Real-Time Library Management System with QR Code Tracking

Target year: SE Sem 3-4 (Mini-Project-I) AICTE: 2 credits · ~50 hrs Bloom: Apply MU CBCS: CSC403 Mini-Project 1A/1B

Real-world project · AICTE-aligned · AI-graded · Audit-ready certificate

Enroll as Student Mentor this project

Milestones

Available mentors

Enrolled students

Core skills

About this project

Build a full-stack library system used by a college library — students issue/return books via QR scan, librarian manages catalogue, dashboard shows real-time circulation. Sends email reminders for overdue books.

Course Learning Outcomes (CLOs):
CLO1: Apply MVC design pattern in a database-driven web application.
CLO2: Design a normalized relational schema for a real-world transactional use-case.
CLO3: Implement role-based authentication + CRUD operations.
CLO4: Demonstrate basic deployment + version control hygiene.

Industry/societal relevance: Every Indian college library does this manually or on legacy software; this gives students a real, deployable artifact for their portfolio.

Milestones

1. Requirement Analysis & Schema Design

15 marks 5d

Document user roles (student, librarian, admin), use cases, ER diagram for books / members / transactions / fines. Submit normalized schema SQL.

2. Authentication & Member Management

20 marks 10d

Implement registration/login (session-based or JWT), member profile, librarian-only views. Submit unit tests for the 3 roles.

3. Book Catalogue + QR Issue/Return

25 marks 15d

CRUD on books, generate per-copy QR code, build issue/return flow that scans QR (or accepts QR string), update inventory counts, log transactions.

4. Overdue Engine + Email Reminders

20 marks 10d

Cron job that scans transactions daily, computes overdue days + fine, sends SMTP email to members. Show fine balance on member profile.

5. Admin Dashboard + Demo Video

20 marks 10d

Dashboard with today's issues/returns, most-borrowed books, overdue list. Record 5-min demo video walking through end-to-end scenario.

Open internships using this project -->

Skills you'll learn

PythonDjango (or Flask)MySQLREST APIsHTML/CSS/JavaScriptQR code generationAuthenticationCRUD operationsGit version control

Tools used

Python 3.11Django 4.xMySQL 8Bootstrap 5qrcode (Python lib)opencv-python (QR scan)SMTP (Gmail/SES)GitHub

Prerequisites

Python fundamentals (CSC301); DBMS basics (CSC402); HTML/CSS/JavaScript intro; familiarity with one MVC framework helpful but optional

Available mentors

No mentors have signed up for this project yet.

Be the first to mentor

You'll earn — Certificate (PDF)

AICTE-aligned Project Completion Certificate

A formal, audit-ready PDF certificate issued by Assessfy + your institute on successful completion. Includes AICTE credit hours, your evaluator's signature, and a QR code for third-party verification.

AICTE-aligned

Certificate of Project Completion

This is to certify that

has successfully completed the project

Real-Time Library Management System with QR Code Tracking

Scan to Verify

Date

Signature

Auto-issued on completion QR-verifiable

You'll earn — Digital Badge

Shareable LinkedIn / Resume Skill Badge

A compact, verifiable Open-Badges-2.0-compliant digital credential. Add to your LinkedIn profile, GitHub README, or resume in one click. Recruiters can validate authenticity via a unique URL.

Beginner

Real-Time Library Management System w…

Assessfy

Auto-issued on completion One-click LinkedIn add