=centercr
@ []QUERY Q 4.7.1: For the time before ED first worked in the Toy
department, find the salary paid, and the time it was paid, of any
employee who was in the Toy department at a time before Ed worked
there.
ANSWER: ``($30K, 1/1/82 – 1/31/82)''
CATEGORY: (Projected, Not Empty) /
(Ordering, Interval, Computed) /
(< >, Constant)
=centercr
@ []QUERY Q 4.7.2: Find the greatest salary under $50K paid to ED and the
times during which it was paid.
ANSWER: ``($40K, 2/1/85 – 1/31/87),'' ``($40k, 4/1/87 – present)''
CATEGORY: (Projected, Not Empty) /
(Containment, Interval, Computed) /
(=, Constant)
=centercr
@ []QUERY Q 4.7.3: Find ED's salary history.
ANSWER: ``($20K, 2/1/82 – 5/31/82),'' ``($30K, 6/1/82 –
1/31/85),'' and ``($40K, (2/1/85 – 1/31/87), (4/1/87 –
present)).''
CATEGORY: (Projected, Not Empty) /
(Containment, Interval, Computed) /
(=, Constant)
=centercr
@ []QUERY Q 4.7.4: For employees that were drivers and simultaneously made less
than $40K, find the names, salaries, and times during which this occurred.
ANSWER: ``(Ed, $20K, 2/1/82 – 5/1/82)'' and ``(Ed, $30K, 6/1/84 –
1/31/85).''
CATEGORY: (Projected, Not Empty) / (Containment, Interval, Computed)
/ (< >, Constant)
=centercr
@ []QUERY Q 4.7.5: For the Toy department when ED worked there, find the
budgets and associated times.
ANSWER: ``(2/1/82 – 7/31/84, $150K),'' ``(8/1/84 – 12/31/86,
$200K),'' and ``(1/1/87 – 1/31/87, $100K)''
CATEGORY: (Projected, Not Empty) /
(Containment, Interval, Computed) /
(=, Constant), (=, Foreign