=centercr
@ []QUERY Q 2.8.1: Find the name and skill pairs sometime possessed by people who
worked in 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 current name and 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 their names (when they reported to DI) for all
people who reported to DI before last year.
ANSWER: ``Ed'' and ``Di.''
CATEGORY: (Complete, None) / (Ordering, Interval, Explicit) / (<, Constant)
=centercr
@ []QUERY Q 2.8.4: Find the current manager of anyone who acquired a skill between
1983 and 1987 inclusive.
ANSWER: ``ED.''
CATEGORY: (Projected, None) / (Containment, Interval, Computed) / (=, Constant)
=centercr
@ []QUERY Q 2.8.5: Find the name current of anyone who lost a skill in the last
four years.
ANSWER: ``Edward.''
CATEGORY: (Projected, None) / (Containment, Interval, Explicit) / (=, Constant)
=centercr
@ []QUERY Q 2.8.6: Find the current name and department of anyone who
changed their name or salary between July 1987 and June 1988
inclusive.
ANSWER: ``(Edward, 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, and current managers and budgets of all
departments with budgets of less than 200K during any period between
January 1, 1985 and December 31, 1989.
ANSWER: ``(Toy, DI, 100K)'' and ``(Book, ED, 50K).''
CATEGORY: (Complete, None) / (Containment, Interval, Explicit) / (< >, Constant)
=centercr
@ []QUERY Q 2.8.9: Who worked in the Toy department at some point and earned at
least 40K throughout the last two years?
ANSWER: ``ED'' and ``DI''
CATEGORY: (Projected, None) / (Containment, Element, Explicit) / (=,
Constant) (< >, Constant)