📚 Online Learning Platform SQL Project

📌 Project Overview

This project is a relational database system designed for an Online Learning Platform using SQL and MySQL Workbench. It demonstrates database design, entity relationships, normalization, and SQL queries for managing courses, students, instructors, enrollments, and learning activities.

---

🛠 Tools Used

• MySQL
• MySQL Workbench
• SQL
• Database Design
• ER Diagram

---

📊 Project Features

• Student Management
• Course Management
• Instructor Management
• Enrollment Tracking
• SQL Queries
• Relational Database Design
• ER Diagram

---

📈 Database Components

• Students Table
• Courses Table
• Instructors Table
• Enrollments Table
• Payments Table (if applicable)
• Relationships using Primary & Foreign Keys

---

🖼 Project Screenshots

ER Diagram

Database Schema

---

💡 Key Learning Outcomes

• Database normalization
• Primary and Foreign Key relationships
• SQL joins and constraints
• Relational database modeling
• Data management using SQL

---

📂 Files Included

• MySQL Workbench File (.mwb)
• SQL Script (.sql)
• ER Diagram Screenshots
• README Documentation

---

👨‍💻 Author

Prashik Meshram

Aspiring Data Analyst

SQL | Python | Power BI | Tableau | Excel