Class remark : Most sensible queries are of similar to "when did X have X.A longer than Y had Y.B?"
=centercr
@ []Query Q 3.3.1: When did somebody have the same salary for the longest total time?
Answer: ``09/01/86–01/01/90''
Category: (None, Element, Derived) / (Duration, Element, Computed) (temporal aggregate) /
=centercr
@ []Query Q 3.3.2: When did anybody work for a manager in a department for as long as
that manager managed that department?
Answer: ``01/01/82–01/01/90''
Category: (None, Element, Derived) / (Duration, Element, Computed) /
=centercr
@ []Query Q 3.3.3: When did one person hold a skill for a longer period than another
but earn a lower salary?
Answer: ``No time.''
Category: (None, Element, Derived) / (Duration, Element, Computed) /
=centercr
@ []Query Q 3.3.4: When did someone manage the Toy department for longer
than Di did?
Answer: ``No time.''
Category: (None, Element, Derived) / (Duration, Element, Computed) / (=,
Constant) (=, Constant)
=centercr
@ []Query Q 3.3.5: When did anyone have a skill longer than Ed had driving?
Answer: ``No time.''
Category: (None, Element, Derived) / (Duration, Element, Computed) / (=,
Constant) (=, Constant)
=centercr
@ []Query Q 3.3.6: When did a department have at least two employees longer than the Toy
department did?
Answer: ``No time.''
Category: (None, Element, Derived) / (Duration, Element, Computed)
(Containment, Element, Computed) / (=, Constant)
=centercr
@ []Query Q 3.3.7: Who worked in one department for at least two years continuously and
what was the period of employment in that department?
Answer: ``(Ed, 02/01/82–01/31/87), (Edward, 01/01/88–01/01/90), (Di, 01/01/82–01/01/90)''
Category: (Projected, Interval, Derived) / (Duration, Interval, Explicit) /