=centercr
@ []QUERY Q 2.7.1: Find the names of all employees that changed department while
DI was working in a department called Toy.
ANSWER: ``Ed'' and ``Edward.''
CATEGORY: (Projected, None) / (Containment, Interval, Computed) (Duration,
Element, Computed) / (=, Constant)
(=, Constant)
=centercr
@ []QUERY Q 2.7.2: Which of all skills ever recorded did ED not acquire while
working in the Book department.
ANSWER: ``Driving,'' ``Directing,'' ``Filing,'' and ``Typing.''
CATEGORY: (Projected, None) / (Containment, Interval, Computed) / (< >, Constant)
=centercr
@ []QUERY Q 2.7.3: Of the skills at some time possessed by ED, list those
he did not acquire while he was working in the Book department.
ANSWER: ``Driving,'' ``Filing,'' and ``Typing.''
CATEGORY: (Projected, None) / (Containment, Interval, Explicit) (Containment,
Interval, Explicit) / (< >, Constant)
=centercr
@ []QUERY Q 2.7.4: For any employee who reacquired a skill, find the name of
the employee when a skill was reacquired.
ANSWER: ``Ed.''
CATEGORY: (Projected, None) / (Ordering, Interval, Computed) (Ordering, Interval,
Computed) / (< >, Constant)
=centercr
@ []QUERY Q 2.7.5: Find the gender and name at the time of all employees that
started working in some department before ED acquired the
skill Driving for the second time.
ANSWER: ``(Ed, M) and (Di, F).''
CATEGORY: (Projected, None) / (Ordering, Interval, Computed) (Ordering, Event,
Computed) / (Sequence, Constant)
=centercr
@ []QUERY Q 2.7.6: Who worked in a department for a given manager for at least the
period when that manager managed that department?
ANSWER: ``ED'' and ``DI.''
CATEGORY: (Projected, None) / (Containment, Interval, Computed) /
=centercr
@ []QUERY Q 2.7.7: What was the highest salary earned by ED before
changing his name to Edward?
ANSWER: ``40K.''
CATEGORY: (Projected, None) / (Ordering, Interval, Computed) / (=, Constant)
(=, Constant)