connect to cs3db3;

create table student(
	ID integer not null,
	name varchar(30),
	primary key (ID)
);


create table room(
	ID integer not null,
	size varchar(10),
	primary key (ID)
);


create table studying(
	studentID integer not null,
	roomID integer not null,
	primary key (studentID, roomID),
	foreign key (studentID) references student (ID) on delete cascade,
	foreign key (roomID) references room (ID) on delete cascade
);

list tables;