-- connect to database;
connect to cs3db3;
--++++++++++++++++++++++++++++++++++++++++++++++
-- CREATE TABLES student, taking, course
--++++++++++++++++++++++++++++++++++++++++++++++

create table Student(
	ID integer not null,
	name varchar(10),
	primary key (ID)
);

create table Course(
	ID integer not null,
	name varchar(10),
	primary key (ID)
);

create table Taking(
	studentID integer not null,
	courseID integer not null,
	primary key (studentID, courseID),
	foreign key (studentID) references  Student (ID) on delete cascade,
	foreign key (courseID) references  Course (ID) on delete cascade
);

list tables;