drop view assign_v2;
create view assign_v2 as
	select r.name as room, t.name as time, s.name as staff
		from assign a
		join room r on r.num = a.rnum
		join time t on t.num = a.tnum
		join staff s on s.num = a.snum
;