=centercr
@ []Query Q 2.1.1: Which departments had managers who served for the shortest
continuous period?
Answer: ``Toy''
Category: (Projected, None) / (Duration, Interval, Computed) /
Here is a case where zero spans should be ignored.
=centercr
@ []Query Q 2.1.2: Who worked continuously in the Book department for as long as Di did?
Answer: ``Ed'' and ``Edward''
Category: (Projected, None) / (Duration, Interval, Computed) / (=, Constant) (=, Constant)
Di never worked in the Book department, so this should return everyone that ever worked in the Book department. Here is a case where zero spans are significant.
=centercr
@ []Query Q 2.1.3: Who worked continuously in the Toy department for as long as Di did?
Answer: ``None''
Category: (Projected, None) / (Duration, Interval, Computed) / (=, Constant) (=, Constant)
=centercr
@ []Query Q 2.1.4: Who worked continuously in a department longer than their
current manager worked in that department?
Answer: ``None''
Category: (Projected, None) / (Duration, Interval, Computed) (Containment, Event, Explicit) /
=centercr
@ []Query Q 2.1.5: Who had the same salary for the longest continuous time period?
Answer: ``Di''
Category: (Projected, None) / (Duration, Interval, Computed) /
=centercr
@ []Query Q 2.1.6: Who worked for a manager in a department for a period as long as
that manager managed that department?
Answer: ``Di''
Category: (Projected, None) / (Duration, Interval, Computed) /
=centercr
@ []Query Q 2.1.7: Which managers served continuously longer than some other manager?
Answer: ``Di''
Category: (Projected, None) / (Duration, Interval, Computed) /