CREATE TABLE SchoolActivity (
	-- School Activity is where School sanctions Activity and Activity has Activity Name,
	ActivityName                            varchar(32) NOT NULL,
	-- School Activity is where School sanctions Activity 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 is where Student represents School in Activity and Activity has Activity Name,
	ActivityName                            varchar(32) NOT NULL,
	-- Student Participation is where Student represents School in Activity and School has School Name,
	SchoolName                              varchar NOT NULL,
	-- Student Participation is where Student represents School in Activity and Student has Student Name,
	StudentName                             varchar NOT NULL,
	PRIMARY KEY(StudentName, ActivityName),
	FOREIGN KEY (StudentName) REFERENCES Student (StudentName)
)
GO