Tech lover | Lifelong learner | Building and growing every day

Hanzala Sheikh  • Peerlist

Student Grading System – Comprehensive SQL Database Project This repository contains a robust Student Grading System implemented entirely with SQL targeting MySQL. It is designed to manage essential academic data including students, courses, instructors, enrollments, and grades with integrity and scalability. The project features a well-normalized relational database schema structured around five main tables: Students: Captures detailed personal and contact information, including enrollment dates. Instructors: Stores educator details linked to courses they teach. Courses: Maintains course catalog with credit information. Enrollments: Tracks student registrations by semester and academic year. Grades: Records assessment results, enabling grade tracking and GPA calculations. Key Capabilities Enforces data integrity using primary and foreign key constraints. Supports complex queries such as GPA calculation, enrollment listings, and performance analytics. Includes sample data for 25 students, multiple instructors, courses, enrollments, and grades to illustrate usage. Provides demonstration SQL queries illustrating CRUD operations, joins, aggregations, updates, and deletes. Designed for easy extension and adaptation, making it suitable for education-related applications or learning environments. Why This Project? This system offers a practical, real-world example of relational database design for educational administration. It showcases: Effective use of SQL features like auto-incrementing primary keys, unique constraints, foreign key relationships, and data normalization. Sample SQL scripts for schema creation (schema.sql), data population (sample_data.sql), and example queries (queries.sql). Practical queries such as student lists, course enrollments, grade retrieval, and GPA computations useful for educators or database learners.