=centercr
@ []QUERY Q 4.3.1: Who, when, and for which department did anybody work for as long as
the length of time that department's budget was below 200K?
ANSWER: ``(DI, Toy, 01/01/82–01/01/90)'' and ``(ED, Book,
4/1/87–01/01/90
CATEGORY: (Projected, Element, Intersection) / (Duration, Element, Computed) /
(< >, Constant)
=centercr
@ []QUERY Q 4.3.2: Who and when did anybody work in a department longer than their
current manager worked in that department?
ANSWER: ``None''
CATEGORY: (Projected, Element, Derived) / (Duration, Element, Computed) / (Containment,
Event, Explicit) /
=centercr
@ []QUERY Q 4.3.3: For all employees who managed any departments at least as long
as DI managed the Toy department, list their names, their
gender, their departments and their salary histories during that
time.
ANSWER: ``(DI, (Di, 01/01/82–01/01/90), F, (Toy,
01/01/82–01/01/90), ((30K, 01/01/82–07/31/84), (40K,
08/01/84–08/31/86), (50K, 09/01/86–01/01/90)))''
CATEGORY: (Projected, Element, Derived) / (Duration, Element, Computed) /
(=, Constant) (=, Constant)
=centercr
@ []QUERY Q 4.3.4: For departments that had a manager that served for the
shortest total time, list the department name, the shortest-serving
manager(s), an the times when those managers served the department.
ANSWER: ``Book, ED, 04/01/87–01/01/90''
CATEGORY: (Projected, Element, Intersection) / (Duration, Element, Computed) /
=centercr
@ []QUERY Q 4.3.5: For all departments which had budgets of at least 200K for a
longer total time than budgets of less than 200K, list their names,
budgets, and times when the budgets were not below 200K.
ANSWER: ``None.''
CATEGORY: (Projected, Element, Derived) / (Duration, Element, Computed) /
(< >, Constant) (< >, Constant)
=centercr
@ []QUERY Q 4.3.6: What skills did ED hold for at least as long as the
total time during his employment that he did not have the Driving
skill, and when did he have those skills?
ANSWER: ``Typing, 04/01/82–01/01/90,'' ``Filing, 01/01/85–01/01/90,'' and
``Driving, (01/01/82–05/01/82, 06/01/84–05/31/88).''
CATEGORY: (Projected, Element, Derived) / (Duration, Element, Computed) /
(=, Constant) (< >, Constant)