Class O3.S6 (Other, Event, Other)


=centercr @ []QUERY Q 4.6.1: Find the name and salary histories of employees whose date-of-birth was after 1/1/56.
ANSWER: ``((Di, (1/1/82–1/1/90), ((30K, 01/01/82–07/31/84), (40K, 08/01/84–08/31/86), (50K, 09/01/86–01/01/90)))''
CATEGORY: (Projected, Element, Derived) / (Ordering, Event, User-defined) /


=centercr @ []QUERY Q 4.6.2: Find the name and salary histories of employees who were called ``Ed'' after 1/1/88.
ANSWER: ``Empty Answer.''
CATEGORY: (Projected, Element, Derived) / (Ordering, Event, User-Defined) /


=centercr @ []QUERY Q 4.6.3: Find the name and salary histories since their latest pay raise of employees whose latest pay raise was in 1985.
ANSWER: ``(((Ed, (2/1/85 – 12/31/87)), (Edward, (1/1/88 – 1/1/90))), (40K, ((2/1/85 – 1/31/87), (4/1/87 – 1/1/90))))''
CATEGORY: (Projected, Element, Derived) / (Containment, Event, Explicit) /


=centercr @ []QUERY Q 4.6.4: Find the name and salary histories of employees whose latest pay raise occurred after the date-of-birth of every other employee.
ANSWER: The answer contains Both DI's and ED's enitre Name and Salary history, see Section [*].
CATEGORY: (Projected, Element, Derived) / (Ordering, Event, User-Defined) /


=centercr @ []QUERY Q 4.6.5: Find the name and salary histories of employees whose latest pay raise occurred on the date-of-birth of some other employee.
ANSWER: ``Empty answer.''
CATEGORY: (Projected, Element, Derived) / (Containment, Event, User-Defined) /


=centercr @ []QUERY Q 4.6.6: Who and when had at least the skills that DI currently has?
ANSWER: ``(DI, (1/1/82–now''
CATEGORY: (Projected, Element, Derived) / (Containment, Event, Explicit) / (=, Constant)