drop view educand_v;
create view educand_v as
	select * from educand e
		where not exists(select * from subject s
			where not exists(select * from assign
				where (s_code, e_code) = (s.code, e.code)
			)
		)
		order by e.code
;
