Class O3.S1 (Duration, Interval, Computed)


=centercr @ []QUERY Q 4.1.1: Who, and when, were continuously employed in the Toy department shorter than DI was continuously employed in the Toy department?
ANSWER: ``ED from 01-Feb-1982 to 31-Jan-1987.''
CATEGORY: (Projected, Interval, Derived) / (Duration, Interval, Computed) / (=, Constant) (=, Constant) (=, Constant)


=centercr @ []QUERY Q 4.1.2: Who, and when, were continuously employed in the Toy department shorter than DI was continuously employed in the Toy department, and what are their gender and date of birth?
ANSWER: ``ED from 01-Feb-1982 to 31-Jan-1987, born 1-Jul-1955 and Male.''
CATEGORY: (Complete, Interval, Derived) / (Duration, Interval, Computed) / (=, Constant) (=, Constant) (=, Constant)


=centercr @ []QUERY Q 4.1.3: Who were continuously employed in the Toy department shorter than DI was continuously employed in the Toy department, and when did this employment start?
ANSWER: ``ED, on 01-Feb-1982.''
CATEGORY: (Projected, Event, Derived) / (Duration, Interval, Computed) / (=, Constant) (=, Constant) (=, Constant)


=centercr @ []QUERY Q 4.1.4: Return the name on 01-Jan-1984 along with the date 01-Jan-1984 for each employee who was continuously employed in the Toy department shorter than DI was continuously employed in that department.
ANSWER: ``Ed, 01-Jan-1984.''
CATEGORY: (Projected, Event, Imposed) / (Duration, Interval, Computed) / (=, Constant) (=, Constant) (=, Constant)