=centercr
@ []QUERY Q 4.8.1: For all employees that have been in the Book or Toy departments
sometime during the last two years, find their current names and
their skills together with the times when they were valid.
ANSWER: ``(Edward, Typing, 1-Apr-1982 to date), (Edward, Filing, 1-Jan-1985 to
date), (Edward, Driving, 1-Jan-1982 to 1-May-1982), (Edward, Driving,
1-Jun-1984 to 31-May-1988) and (Di, Directing, 1-Jan-1982 to date).''
CATEGORY: (Projected, Element) / (Containment, Interval, Explicit) / (=, Constant)
(=, Constant)
=centercr
@ []QUERY Q 4.8.2: Find the current names of all people who reported to DI
before last year along with the time when they reported to her.
ANSWER: ``(Edward, 1-Feb-1982 to 31-Jan-1987)''
CATEGORY: (Projected, None) / (Containment, Interval, Computed) / (<, Constant)
=centercr
@ []QUERY Q 4.8.3: Find the manager and time when a skill was acquired between
1983 and 1987 (inclusive) by anyone who acquired a skill between
these times.
ANSWER: ``(DI, 1-Jun-1984) and (DI, 1-Jan-1985).''
CATEGORY: (Projected, None) / (Containment, Interval, Computed) / (=, Constant)
=centercr
@ []QUERY Q 4.8.4: For anyone who had two raises in the period March 1982 to March
1985 (inclusive), find the current name and the dates when raises
occurred during the aforementioned times.
ANSWER: ``(Edward, 1-Jun-1982, 1-Feb-1985).''
CATEGORY: (Projected, None) / (Containment, Interval, Computed) / (=, Constant)