GitHunt
VI

vinaykumar2331/University-SQL-Project

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.

๐ŸŽ“ 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