=centercr
@ []Query Q 2.8.1: Find the name and skills of all people who worked for the BOOK or
TOY department last year.
Answer: ``(Edward, Typing), (Edward, Filing), (Edward, Driving), (Ed, Typing),
(Ed, Filing), (Ed, Driving) and (Di, Directing).''
Category: (Complete, None) / (Containment, Interval, Explicit) / (=, Constant) (=,
Constant)
=centercr
@ []Query Q 2.8.2: Find the name and current skills of all people who worked for the
BOOK or TOY department last year.
Answer: ``(Edward, Typing), (Edward, Filing) and (Di, Directing).''
Category: (Complete, None) / (Containment, Interval, Computed) (Containment,
Interval, Explicit) / (=, Constant) (=, Constant)
=centercr
@ []Query Q 2.8.3: Find the name of all people who reported to DI before last year.
Answer: ``Ed''
Category: (Complete, None) / (Ordering, Interval, Explicit) / (<, Constant)
=centercr
@ []Query Q 2.8.4: Find the manager of anyone who acquired a skill between 1983 and
1987 inclusive.
Answer: ``Di.''
Category: (Projected, None) / (Containment, Interval, Computed) / (=, Constant)
=centercr
@ []Query Q 2.8.5: Find the name of anyone who lost a skill in the last four years.
Answer: ``().''
Category: (Projected, None) / (Containment, Interval, Explicit) / (=, Constant)
=centercr
@ []Query Q 2.8.6: Find the name and department of anyone who changed their name or
salary between July 1987 and June 1988 inclusive.
Answer: ``(Ed, Book).''
Category: (Projected, None) / (Containment, Interval, Computed) / (=, Constant)
=centercr
@ []Query Q 2.8.7: Which employees stayed at their first salary for less than one year?
Answer: ``Ed''
Category: (Projected, None) / (Containment, Interval, Explicit) /
=centercr
@ []Query Q 2.8.8: List the names, managers and budgets of all departments with budgets
of less than 200K during any period between Jan 1, 1985 and
Dec 31, 1989?
Answer: ``(Toy, Di, 100K)''
Category: (Complete, None) / (Containment, Interval, Explicit) / (< >, Constant)
=centercr
@ []Query Q 2.8.9: Who worked in the Toy department and earned at least 40K in the
last two years?
Answer: ``Edward'' and ``Di''
Category: (Projected, None) / (Containment, Element, Explicit) / (=, Constant) (< >, Constant)