=centercr
@ []Query Q 4.8.1: Find the name, active skills and period of all people who worked for
the BOOK or TOY department in the last two years.
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: (Complete, Element) / (Containment, Interval, Explicit) / (=, Constant)
(=, Constant)
=centercr
@ []Query Q 4.8.2: Find the name, active skills and relevant period of all people who
worked for the BOOK or TOY department in the last two years.
Answer: ``(Edward, Typing, 1-Apr-1982 to date), (Edward, Filing, 1-Jan-1985 to
date), (Edward, Driving, 1-Jun-1984 to 31-May-1988) and (Di, Directing,
1-Jan-1982 to date).''
Category: (Complete, Element) / (Containment, Interval, Computed) (Duration,
Interval, Explicit) / (=, Constant) (=, Constant)
=centercr
@ []Query Q 4.8.3: Find the name and period of all people who reported to DI before
last year.
Answer: ``(Ed, 1-Feb-1982 to 31-Jan-1987)''
Category: (Complete, None) / (Containment, Interval, Computed) / (<, Constant)
=centercr
@ []Query Q 4.8.4: Find the manager and date of anyone who acquired a skill between
1983 and 1987 inclusive.
Answer: ``(Di, 1-Jun-1984) and (Di, 1-Jan-1985).''
Category: (Projected, None) / (Containment, Interval, Computed) / (=, Constant)
=centercr
@ []Query Q 4.8.5: Find the name and dates of anyone who had two raises in the period
March 1982 to March 1985 inclusive.
Answer: ``(Ed, 1-Jun-1982, 1-Feb-1985).''
Category: (Projected, None) / (Containment, Interval, Computed) / (=, Constant)