Mini Project Topics (with SQL Database Design Concepts)
1. Library Management System – Heanisha and Team
o Entities: Books, Authors, Members, Borrow/Return Transactions, Fines
o Concepts: Primary/foreign keys, relationships (1:M, M:N),
Features of the Project:
● Book inventory management
● Borrower and return system
● Tracking of late fees and due dates
● User roles (admin, borrower)
2. Online Food Ordering System –Gukaraja devi and Team
o Entities: Restaurants, Menu Items, Customers, Orders, Payments, Delivery
o Concepts: Normalization (menu redundancy), JOIN queries, indexing for search.
3. Student Attendance and Marks Management – Sabarish.S and Team
o Entities: Students, Courses, Instructors, Attendance Records, Marks/Grades
o Concepts: Constraints, aggregate functions (AVG, MAX), views for progress
reports.
Features of the Project:
● Course enrollment and grade tracking
● GPA calculation
● Multiple roles (student, teacher)
● Real-time grade management
4. Hospital/Clinic Management System – Murugesh and Team
o Design a database to manage patient records, appointments, doctors, and
departments.
o Entities: Patients, Doctors, Appointments, Treatments, Billing
Features of the Project:
● Patient record management
● Doctor assignment and scheduling
● Medical history tracking
● Treatment plans and discharge summaries
5. E-Commerce Store Database – Diksith ram and Team
o Entities: Customers, Products, Orders, Cart, Payment, Shipment
o Concepts: Many-to-many relationships (Products ↔ Orders), views for sales
reports, triggers for stock updates.
Features of the Project:
● Product management with categories and suppliers
● Search functionality based on product attributes
● Real-time product availability updates
● Supplier management system
6. Banking System (Mini Version) – Sowmith and Team
o Entities: Customers, Accounts, Transactions, Loans, Cards
o Concepts: Triggers for balance updates, transactions with rollback, indexing.
7. Movie Ticket Booking System – Divyadharsan and Team
o Entities: Movies, Theatres, Shows, Seats, Customers, Payments
o Concepts: Composite keys (Show + Seat), check constraints, transaction handling.
8. Hotel Room Reservation System – Boomika and Team
o Create a database to manage rooms, guests, bookings, and payments.
o Entities: Hotels, Rooms, Customers, Reservations, Payments
o Concepts: Normalization, triggers for booking status update, views for
availability.
Features of the Project:
● Room booking and availability management
● Customer details tracking
● Real-time room status updates
● Multiple user roles (admin, customer)
9. Inventory Management System –Deepak and Team
● Entities: Products, Suppliers, Purchase Orders, Stock, Sales
● Concepts: Joins, aggregate queries, triggers for stock level alerts.
10. Airline Management System – Rinisha and Team
Entities: Flights, Aircraft, passenger, Booking, Employee, Routes, Airport
Project Structure:-
● Database Design: Define your entities and their relationships (e.g., a simple e-commerce system
with Customers, Products, Orders, OrderItems).
● Draw ER diagram
● Schema Creation: Use DDL to create all necessary tables. Perform all DDL Commands
● Data Population: Use DML to insert a reasonable amount of sample data.
● Query Demonstrations: Write a series of SELECT queries that demonstrate various filtering,
sorting, grouping, joining, and advanced SQL techniques to answer specific "business questions"
related to your chosen database.
● Write Queries for Analysis and Reporting:
o Basic Queries: Use SELECT statements with WHERE clauses to filter data.
o Joins: Combine data from multiple tables using JOIN operations (e.g., INNER
JOIN, LEFT JOIN).
o Aggregate Functions: Calculate summaries
using COUNT, SUM, AVG, MIN, MAX with GROUP BY.
o Subqueries and CTEs (Common Table Expressions): Perform more complex
data retrieval and manipulation.
o Data Modification: Use UPDATE and DELETE to modify or remove data if
required for specific scenarios.
o Views, indexes
● Refine and Optimize (Optional):
o Consider adding indexes to frequently queried columns to improve performance.
o If the project grows, explore views, stored procedures, or functions for modularity
and reusability.
