Mini Project (Library Management, E-commerce, etc.)

Mini projects are small-scale DBMS applications designed to demonstrate real-world modeling, querying, and data handling. You can guide your students to focus on concept-to-implementation stages.

1. Library Management System

Objective: Maintain records of books, members, borrow/return logs, and fines.

Core Components:

• Tables: Books, Members, Borrow, Return, Staff, Fines
• Features: Issue/Return book, calculate overdue fine, search books, generate reports

DB Concepts Used:

• ER modeling
• Foreign keys (e.g., member_id in Borrow)
• Triggers (e.g., update Fines after due date)
• Views (for monthly reports)
• Normalization (3NF design)

2. E-Commerce Order System

Objective: Manage users, products, orders, inventory, and transactions.

Core Components:

• Tables: Users, Products, Orders, OrderItems, Payments, Cart
• Features: Place order, check stock, make payments, order history

DB Concepts Used:

• Joins (products with orders)
• Transactions (to ensure payment consistency)
• Stored Procedures (order fulfillment)
• Indexing (on ProductID, OrderDate)
• Triggers (update stock on order)

3. Student Attendance & Marks System

Objective: Track student attendance and marks subject-wise, semester-wise.

Core Components:

• Tables: Students, Subjects, Attendance, Marks, Teachers
• Features: Record attendance, view reports, grade calculation

DB Concepts Used:

• Aggregate functions (AVG, COUNT)
• Composite keys (student_id + subject_id)
• Views (attendance percentage report)
• Constraints (e.g., max marks ≤ 100)
• Normalized data model

4. Hospital Management System

Objective: Manage patients, appointments, billing, and medical records.

Core Components:

• Tables: Patients, Doctors, Appointments, Prescriptions, Bills
• Features: Schedule appointments, generate bills, patient history

DB Concepts Used:

• Date/time functions
• Relational integrity
• Transactions (admission + discharge)
• Backup/restore simulation (for recovery topic)
• ER diagram and normalization

Tips for Implementation

• Front-End (Optional): Can be done via Python, PHP, Java, etc.
• SQL Implementation: Focus on DDL, DML, and writing real queries.
• Schema Design: Start with ER diagrams and normalization.
• Report & Demo: Ensure students document assumptions, queries, and screenshots.