drop view assign_v1;
create view assign_v1 as
	select r.name as room, t.name as time, s.name as staff
		from assign a, room r, time t, staff s
		where (r.num, t.num, s.num) = (a.rnum, a.tnum, a.snum)
;