Skip to content

README.md

Latest commit

 

History

History
35 lines (23 loc) · 1.17 KB

README.md

File metadata and controls

35 lines (23 loc) · 1.17 KB

🎓 University SQL project (MySQL)

This project is a relational database system designed to manage and organize data within a university setting. The system models essential components of academic operations, including student records, professor information, courses offered, and course enrollments.

The database is implemented using SQL and demonstrates best practices in relational database design, including the use of primary keys, foreign keys, and normalization principles. It also includes sample data to simulate real-world use cases.

🗂️ Folder Structure

  • create_tables/: Contains structure of the data Tables
  • insert_tables/: Contains data in the tables
  • queries/: Contains queries and solutions

📘 Topics Covered

  • SELECT, WHERE, ORDER BY
  • JOINs (INNER, LEFT)
  • GROUP BY, COUNT, HAVING
  • Subqueries
  • Filtering and Aggregation

🧱 Tables

  • Students
  • Professors
  • Courses
  • Enrollments (many-to-many link between students and courses)

💻 How to Run

  1. Use any MySQL environment (e.g., MySQL CLI, MySQL Workbench, phpMyAdmin).
  2. Run schema/create_tables.sql
  3. Run schema/insert_data.sql
  4. Practice with queries in the queries/ folder