=centercr
@ []QUERY Q 2.9.1: Find the names of departments that always had a budget greater
than $90K during the times when managed by someone named Di.
ANSWER: ``Toy.''
CATEGORY: (Projected, None) / (Containment, Element, Computed) / (=, Constant)
(=, Constant) (=, Foreign)
=centercr
@ []QUERY Q 2.9.2: Find ED's salaries when he worked in the same
department as DI.
ANSWER: ``$20K, $30K, $40K.''
CATEGORY: (Projected, None) / (Containment, Element, Computed) / (=, Constant)
(=, Single) (=, Constant)
=centercr
@ []QUERY Q 2.9.3: Find the names of the departments that ED worked in
while earning $40K.
ANSWER: ``Toy'' and ``Book.''
CATEGORY: (Projected, None) / (Containment, Element, Computed) / (=, Constant)
(=, Constant)
=centercr
@ []QUERY Q 2.9.4: Find ED's names after he left the Toy department.
ANSWER: ``Ed'' and ``Edward.''
CATEGORY: (Projected, None) / (Ordering, Element, Computed) / (=, Constant) (=,
Constant)
=centercr
@ []QUERY Q 2.9.5: Find the skills that ED possessed sometime when he
worked in the Toy department.
ANSWER: ``Driving,'' ``Filling,'' and ``Typing.''
CATEGORY: (Projected, None) / (Containment, Element, Computed) / (=, Constant)
(=, Foreign) (=, Constant)
=centercr
@ []QUERY Q 2.9.6: What new skills did ED obtain after he had changed his
name to Edward?
ANSWER: ``None.''
CATEGORY: (Projected, None) / (Ordering, Element, Computed) / (=, Constant) (=, Constant)
=centercr
@ []QUERY Q 2.9.7: What were Toy's departmental budgets when it had a manager
named Di?
ANSWER: ``150K,'' ``200K,'' and ``100K.''
CATEGORY: (Projected, None) / (Containment, Element, Computed) / (=, Constant)
(=, Constant)