=centercr
@ []Query Q 3.1.1: Find the times when persons with a shorter employment in the
Toy department than DI were employed in the Book department.
Answer: ``{ [4/1/87 - now]}''
Category: (None, Element, Derived) / (Duration, Element, Computed) / (=,
Constant)
=centercr
@ []Query Q 3.1.2: Find the employment periods of persons that made 40K for a
longer time than when DI made 40K.
Answer: ``{ [2/1/82 - 1/31/87], [4/1/87 - now]}''
Category: (None, Element, Derived) / (Duration, Element, Computed) / (=,
Constant)
=centercr
@ []Query Q 3.1.3: Find the starting times in the Book department of persons which
possessed the Filing skill for a longer time than DI.
Answer: ``{ 4/1/87}''
Category: (None, Element, Derived) / (Duration, Element, Computed) / (=,
Constant)
=centercr
@ []Query Q 3.1.4: Return the times when persons employed a shorter time than DI
acquired a skill.
Answer: ``{ 1/1/82, 4/1/82, 6/1/84, 1/1/85, }''
Category: (None, Element, Derived) / (Duration, Element, Computed) / (=,
Constant)
=centercr
@ []Query Q 3.1.5: Find the employment periods of persons employed shorter time
than DI.
Answer: ``{ [2/1/82 - 1/31/87], [4/1/87 - now]}''
Category: (None, Element, Derived) / (Duration, Element, Computed) /(=,
Constant)
=centercr
@ []Query Q 3.1.6: When did someone get a raise more quickly than Di's first raise?
Answer: ``06/01/82'' and ``09/01/86''
Category: (None, Event, Derived) / (Duration, Interval, Computed) (Ordering,
Interval, Computed) / (= ,Constant)
=centercr
@ []Query Q 3.1.7: When was the longest period when no one was hired or left employment?
Answer: ``02/01/82–01/01/90''
Category: (None, Interval, Derived) / (Duration, Interval, Computed) /
=centercr
@ []Query Q 3.1.8: When was the longest period when no one received a raise?
Answer: ``06/02/82–07/31/84''
Category: (None, Interval, Derived) / (Duration, Interval, Computed) /
=centercr
@ []Query Q 3.1.9: When was the longest period when a department was without a manager?
Answer: ``04/01/87–01/01/90''
Category: (None, Interval, Derived) / (Duration, Interval, Computed) /