CREATE TABLE SchoolActivity (
-- School Activity involves Activity and Activity has Activity Name, ActivityName varchar(32) NOT NULL, -- School Activity involves School and School has School Name, SchoolName varchar NOT NULL, PRIMARY KEY(SchoolName, ActivityName)
) GO
CREATE TABLE Student (
-- Student is enrolled in School and School has School Name, SchoolName varchar NOT NULL, -- Student has Student Name, StudentName varchar NOT NULL, PRIMARY KEY(StudentName)
) GO
CREATE TABLE StudentParticipation (
-- Student Participation involves Activity and Activity has Activity Name, ActivityName varchar(32) NOT NULL, -- Student Participation involves School and School has School Name, SchoolName varchar NOT NULL, -- Student Participation involves Student and Student has Student Name, StudentName varchar NOT NULL, PRIMARY KEY(StudentName, ActivityName), FOREIGN KEY (StudentName) REFERENCES Student (StudentName)
) GO