11 lines
224 B
SQL
11 lines
224 B
SQL
CREATE TABLE Enrollments
|
|
(
|
|
studentID INT,
|
|
courseID INT,
|
|
letterGrade CHAR(2),
|
|
PRIMARY KEY(studentID, courseID),
|
|
FOREIGN KEY(studentID)
|
|
REFERENCES Students(studentID)
|
|
ON DELETE NO ACTION
|
|
ON UPDATE CASCADE
|
|
); |