Anonymous

CREATE TABLE Tutor
(
Id CHAR(10),
CrsCode CHAR(8),
Year INTEGER,
ClassTime CHAR(5),
Semester CHAR(2),

PRIMARY KEY (Id,CrsCode,Year,ClassTime,Semester),
FOREIGN KEY (Id) REFERENCES Student(Id),
FOREIGN KEY (CrsCode) REFERENCES CourseOffering(CrsCode),
FOREIGN KEY (Year) REFERENCES CourseOffering(Year),
FOREIGN KEY (ClassTime) REFERENCES CourseOffering(ClassTime),
FOREIGN KEY (Semester) REFERENCES CourseOffering(Semester)
);