=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 throughout
the past 5 years?
ANSWER: ``DI''
CATEGORY: (Projected, None) / (Duration, Interval, Explicit) (Containment,
Event, Explicit) /
=centercr
@ []QUERY Q 2.2.4: For each department which has had the same managers and budget
for the last 18 months, list its current name, manager, and budget.
ANSWER: ``(Toy, DI, 100K)'' and ``(Book, ED, 50K)''
CATEGORY: (Complete, None) / (Duration, Interval, Explicit) (Containment,
Event, Explicit) /
=centercr
@ []QUERY Q 2.2.5: Who has worked in the Toy department and has earned at least
40K throughout the last two years?
ANSWER: ``ED'' 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: ``None''
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) /