Student Management System using SQL

Overview

The Student Management System is a SQL-based database project developed using MySQL. It demonstrates relational database design, CRUD operations, joins, aggregate functions, views, stored procedures, triggers, and indexing.

Technologies Used

• MySQL
• SQL
• MySQL Workbench

Database Tables

1. Students
2. Courses
3. Faculty
4. Enrollment
5. Student_Log

Features

• Student Record Management
• Course Management
• Enrollment Management
• CRUD Operations
• SQL Joins
• Aggregate Functions
• Stored Procedure
• Trigger
• View
• Index

SQL Concepts Used

• CREATE DATABASE
• CREATE TABLE
• INSERT
• UPDATE
• DELETE
• SELECT
• WHERE
• ORDER BY
• GROUP BY
• HAVING
• INNER JOIN
• LEFT JOIN
• Aggregate Functions
• VIEW
• STORED PROCEDURE
• TRIGGER
• INDEX

Author

Kunal Bansal