=centercr
@ []QUERY Q 3.7.1: When did the Toy budget decrease?
ANSWER: ``1/1/87.''
CATEGORY: (None, Event, Derived) /
(Ordering, Interval, Computed) /
(=, Constant) (< >, Single)
=centercr
@ []QUERY Q 3.7.2: When did an employee change name?
ANSWER: ``1/1/88.''
CATEGORY: (None, Event, Derived) /
(Ordering, Interval, Computed) /
(=, Single) (< >, Single)
=centercr
@ []QUERY Q 3.7.3: When did the salary of an employee increase while the employee
was a manager?
ANSWER: ``8/1/84'' and ``9/1/86.''
CATEGORY: (None, Event, Derived) /
(Ordering, Interval, Computed)
(Containment, Element, Computed) /
(=, Foreign) (=, Const) (< >, Single)
=centercr
@ []QUERY Q 3.7.4: Find the periods during which DI earned $40K and was a
manager of the Toy department.
ANSWER: ``8/1/84 – 8/31/86.''
CATEGORY: (None, Element, Intersection) /
(Containment, Interval, Computed) /
(=, Constant)
=centercr
@ []QUERY Q 3.7.5: Find the acquisition dates of the skills ED acquired
before or during the year he joined the Toy department.
ANSWER: ``1/1/82'' and ``4/1/82.''
CATEGORY: (None, Event, Derived) /
(Containment, Interval, Computed) /
(=, Constant)