🎓 Student Course Enrollment SQL Project

📌 Project Overview

This project demonstrates the design and implementation of a Student Course Enrollment Management System using MySQL. It covers database design, table relationships, data insertion, and real-world SQL queries commonly asked in interviews.

---

🗂 Database Schema

The project consists of three tables:

• Students
• Courses
• Enrollments

Relationships:

• One student can enroll in multiple courses.
• One course can have multiple students.
• The Enrollments table connects Students and Courses using foreign keys.

---

🛠 Technologies Used

• MySQL
• SQL
• Git
• GitHub

---

📁 Project Structure

Student-Course-Enrollment-SQL/
│── schema.sql
│── data.sql
│── queries.sql
│── README.md
└── screenshots/

---

🚀 SQL Concepts Covered

• CREATE DATABASE
• CREATE TABLE
• PRIMARY KEY
• FOREIGN KEY
• INSERT
• SELECT
• WHERE
• ORDER BY
• DISTINCT
• LIKE
• BETWEEN
• INNER JOIN
• LEFT JOIN
• GROUP BY
• HAVING
• COUNT()
• SUM()
• AVG()
• MIN()
• MAX()
• UPDATE
• DELETE
• CASE
• Subqueries
• Views

---

📊 Sample Queries

• List all students
• Find students from a specific city
• Display enrolled courses for each student
• Count students per course
• Find the most popular course
• Calculate average student age
• Show students with grade A
• Department-wise course statistics
• Students enrolled in multiple courses

---

🎯 Learning Outcomes

• Designed a relational database.
• Implemented primary and foreign key relationships.
• Wrote basic, intermediate, and advanced SQL queries.
• Practiced real-world reporting and interview-style SQL problems.

---

📸 Screenshots

Add screenshots of:

• Database tables
• Query results
• JOIN operations
• GROUP BY and HAVING queries

---

👩‍💻 Author

Madiha Mahvish

GitHub: https://github.com/YOUR_GITHUB_USERNAME