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