create view department as select deptno, dname, cast(multiset(select empno, ename, sal from emp where emp.deptno = dept.deptno ) as emp_list ) employees from dept;