=centercr
@ []Query Q 2.7.1: Find the names of all employees that changed departments 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: Find the skills ED did not acquire while he was 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: Find the manager and department of anyone who let a skill
lapse for more than a month while their salary was less than $30K.
Answer: ``(Di, Toy).''
Category: (Projected, None) / (Containment, Interval, Computer) (Duration,
Interval, Explicit) / (=, Constant) (=, Constant)
=centercr
@ []Query Q 2.7.5: Find the name of anyone who reacquired a skill.
Answer: ``Ed.''
Category: (Projected, None) / (Ordering, Interval, Computed) (Ordering, Interval,
Computed) / (< >, Constant)
=centercr
@ []Query Q 2.7.6: Find the name and sex of all employees that started work anywhere
before ED acquired the skill driving for the 2nd time.
Answer: ``(Ed, M) and (Di, F).''
Category: (Projected, None) / (Ordering, Interval, Computed) (Ordering, Event,
Computed) / (Sequence, Constant)
=centercr
@ []Query Q 2.7.7: Who worked in a department for a given manager for at least the
period when that manager managed that department?
Answer: ``Di''
Category: (Projected, None) / (Containment, Interval, Computed) /
=centercr
@ []Query Q 2.7.8: What was the highest salary earned by Ed before changing his
name to Edward?
Answer: ``40K''
Category: (Projected, None) / (Ordering, Interval, Computed) / (=, Constant)
(=, Constant)