MySQL Real-World Projects: Student Management System

Create the Student Management Database Schema

Design and create the Students, Courses, and Enrollments tables with appropriate columns and constraints.

Expected output: Three tables created with correct relationships and constraints.

Hint: Use primary keys, foreign keys, and appropriate data types.

Write Queries to Manage Students

Write SQL queries to insert, update, delete, and select student records.

Expected output: Working CRUD queries for the Students table.

Hint: Test each query to ensure it works as expected.

Query Students with Their Enrolled Courses

Write a JOIN query to list all students along with the courses they are enrolled in.

Expected output: A result set showing student names and their course names.

Hint: Use INNER JOIN between Students, Enrollments, and Courses tables.

The Enrollment table manages the many-to-many relationship between students and courses by linking student IDs with course IDs.

Foreign keys enforce referential integrity by ensuring that relationships between tables remain consistent.

You would use the UPDATE statement with a WHERE clause to modify the student's email, for example: UPDATE Students SET email = 'newemail@example.com' WHERE student_id = 1;