=centercr
@ []Query Q 2.2.1: Which employees had the same salary for a single period of
at least three years?
Answer: ``Di''
Category: (Projected, None) / (Duration, Interval, Explicit) /
=centercr
@ []Query Q 2.2.2: Who worked for the same manager for at least five years continuously?
Answer: ``Ed'' and ``Di''
Category: (Projected, None) / (Duration, Interval, Explicit) /
=centercr
@ []Query Q 2.2.3: Which employees have stayed in the same department for the past 5 years?
Answer: ``Di''
Category: (Projected, None) / (Duration, Interval, Explicit) (Containment, Event, Explicit) /
Could also be classified as (Containment, Interval, Explicit.)
=centercr
@ []Query Q 2.2.4: For all departments which have not changed managers AND their budgets
for the last 18 months, list their names, the managers and the budgets.
Answer: ``(Toy, Di, 100K)''
Category: (Complete, None) / (Duration, Interval, Explicit) (Containment, Event, Explicit) /
=centercr
@ []Query Q 2.2.5: Who worked in the Toy department and earned at least 40K for the
last two years?
Answer: ``Edward'' and ``Di''
Category: (Projected, None) / (Duration, Interval, Explicit) / (=, Constant)
(< >, Constant)
=centercr
@ []Query Q 2.2.6: Who had at least three raises in a continuous five-year period?
Answer: ``Ed'' and ``Di''
Category: (Projected, None) / (Duration, Interval, Explicit) /
=centercr
@ []Query Q 2.2.7: Who had the most raises in a continuous five-year period?
Answer: ``Ed'' and ``Di''
Category: (Projected, None) / (Duration, Interval, Explicit) /