Untitled

CREATE TABLE StudentEnrollment (
    student_id INT,
    class_id INT,
    semester VARCHAR(10),
    enrollment_date DATE,
    PRIMARY KEY (student_id, class_id, semester)
);


INSERT INTO StudentEnrollment (student_id, class_id, semester, enrollment_date) VALUES
(1001, 201, 'Fall2025', '2025-09-01'),
(1002, 202, 'Fall2025', '2025-09-02'),
(1001, 203, 'Fall2025', '2025-09-03'),
(1003, 201, 'Fall2025', '2025-09-04'),
(1002, 203, 'Fall2025', '2025-09-05');


SELECT * FROM StudentEnrollment
WHERE student_id = 101 AND semester = 'Fall2025';