drop table assign cascade;
create table assign(
	rnum integer references room(num),
	tnum integer references time(num),
	snum integer references staff(num)
);
insert into assign values(1, 2, 3);
insert into assign values(2, 3, 1);
insert into assign values(3, 1, 2);