StudentID INT AUTO_INCREMENT PRIMARY KEY,
StudentNumber VARCHAR(20) NOT NULL,
FirstName VARCHAR(50) NOT NULL,
LastName VARCHAR(50) NOT NULL,
Email VARCHAR(100) UNIQUE,
City VARCHAR(50)
);


CREATE TABLE Course (
CourseID INT AUTO_INCREMENT PRIMARY KEY,
CourseCode VARCHAR(20) NOT NULL,
CourseName VARCHAR(100) NOT NULL, Units INT
);

CREATE TABLE Enrollment (
'StudentID' INT AUTO_INCREMENT Primary key, 'StudentID' INT,Foreign Key(StudentID) REFERENCES Students(StudentID), 'CourseID' INT,Foreign Key(CourseID) REFERENCES 'Courses' (CourseID),
EnrolmentDate DATE, Semester VARCHAR(20));

CREATE TABLE Enrollment (
EnrollmentID INT NOT NULL AUTO_INCREMENT,
StudentID INT NOT NULL,
CourseID INT NOT NULL,
EnrollmentDate DATE,
Semester VARCHAR(20),
Primary Key (EnrollmentID),
FOREIGN KEY (StudentID) REFERENCES Students(StudentID),
FOREIGN KEY (CourseID) REFERENCES Courses(CourseID),
);




