Class O3.S2 (Duration, Interval, Other)


=centercr @ []QUERY Q 4.2.1: When was the Toy department's budget constant and greater than $175K for more than one year, and what was the budget?
ANSWER: ``$200K from 01-Aug-1984 to 31-Dec-1986.''
CATEGORY: (Projected, Interval, Derived) / (Duration, Interval, Supplied) / (≠, Constant) (=, Constant)


=centercr @ []QUERY Q 4.2.2: When was the Toy department's budget constant and greater than $175K for more than one year, and who was the manager for that time?
ANSWER: ``From 01-Aug-1984 to 31-Dec-1986, managed by DI.''
CATEGORY: (Projected, Interval, Derived) / (Duration, Interval, Supplied) / (≠, Constant) (=, Constant)


=centercr @ []QUERY Q 4.2.3: Who managed a department with a budget that exceeded $175K and then held constant for one year, and when did that occur?
ANSWER: ``DI, from 01-Aug-1984 to 31-Dec-1986.''
CATEGORY: (Projected, Interval, Intersection) / (Duration, Interval, Supplied) / (=, Constant) (=, Foreign)


=centercr @ []QUERY Q 4.2.4: What departments were in continuous operation (and when) longer than the duration between ED's and DI's birth dates?
ANSWER: ``Toy, from 01-Jan-1982 to present.''
CATEGORY: (Projected, Interval, Derived) / (Duration, Interval, Computed) / (=, Constant) (=, Constant)


=centercr @ []QUERY Q 4.2.5: Who worked in one department for at least two years continuously and what were the periods of employment in that department?
ANSWER: ``{ (ED, { [2/1/82 - 1/31/87] }), (ED, { [4/1/87 - 1/1/90] }), (DI, { [1/1/82 - 1/1/90] }) }''
CATEGORY: (Projected, Element, Derived) / (Duration, Interval, Explicit) /