This preview shows page 1. Sign up to view the full content.
Unformatted text preview: birthday date ); create table Emp ( ename varchar (30), ChildrenSet Children multiset , SkillSet Skills multiset ); b) (i) select distinct s.type from emp as e , unnest ( e.SkillSet ) as s (ii) select e.ename from Emp as e , unnest ( e.SkillSet ) as s where s.type = ’typing’ (iii) select ename , cs.name from Emp as e, unnest ( e.ChildrenSet ) as cs order by cs.birthday (iv) update Emp set ChildrenSet = ChildrenSet union multiset [(‘‘Jeb’’, ‘‘2/5/2001’’)] where ename = ‘‘George’’...
View Full Document
- Winter '11