Class O1.S5 (Other, Event, Computed)


=centercr @ []QUERY Q 2.5.1: Find ED's skills when he joined the Book department
ANSWER: ``typing,'' ``filing'' and ``driving.''
CATEGORY: (Projected, None) / (Containment, Event, Computed) / (=, Constant)


=centercr @ []QUERY Q 2.5.2: Find the name and the budget of ED's departments when he joined them.
ANSWER: ``(Toy, $150K)'' and ``(Book, $50K).''
CATEGORY: (Projected, None) / (Containment, Event, Computed) / (=, Constant) (=, Foreign)


=centercr @ []QUERY Q 2.5.3: For each employee who was in the Toy department when it opened, find all data and skills that were valid at the time.
ANSWER: ``(Di, $30K, Toy, F, 10/1/60, directing).''
CATEGORY: (Complete, None) / (Containment, Event, Computed) / (=, Constant) (=, Foreign)


=centercr @ []QUERY Q 2.5.4: Find the names valid when the budget of the Toy department was decreased of the employees who had been working in the Toy department before the budget was decreased.
ANSWER: ``Ed'' and ``Di''
CATEGORY: (Projected, None) / (Ordering, Event, Computed) (Ordering, Interval, Computed) / (=, Constant) (< >, Constant)


=centercr @ []QUERY Q 2.5.5: Find ED's skills when his salary increased from $30K to $40K.
ANSWER: ``typing,'' ``filing'' and ``driving.''
CATEGORY: (Projected, None) / (Containment, Event, Computed) (Ordering, Interval, Computed) / (=, Constant)