=centercr
@ []Query Q 4.7.1: Find the salary paid and the time it was paid, of any toy department employee before Ed worked there.
Answer: ``(Di, $40K, 1/1/1982 – 7/31/1984)''
Category: (Projected, Not Empty) /
(Ordering, Interval, Computed) /
(< >, Constant)
=centercr
@ []Query Q 4.7.2: Find the greatest salary paid to Ed under $50K and the times during which it was paid.
Answer: ``($40K, 2/1/1985 – 1/31/1987),'' ``($40k, 4/1/1987 – present)''
Category: (Projected, Not Empty) /
(Containment, Interval, Computed) /
(=, Constant)
=centercr
@ []Query Q 4.7.3: Find Ed's salary history.
Answer: ``(Ed, $20K, 2/1/1982 – 5/31/1982),'' ``(Ed, $30K, 6/1/1982 – 1/31/1985),''
``(Ed, $40K, 2/1/1985 – 1/31/1987),'' ``(Ed, $40k, 4/1/1987 – present)''
Category: (Projected, Not Empty) /
(Containment, Interval, Computed) /
(=, Constant)
=centercr
@ []Query Q 4.7.4: Find the name, salary and the time during which this occured, for drivers who made less than $40K.
Answer: ``(Ed, $20K, 1/1/1982 – 5/1/1982),'' ``(Ed, $30K, 6/1/1984 –
1/31/1985),'' ``(Di, $30K, 1/1/1982 – 7/31/1984)''
Category: (Projected, Not Empty) / (Containment, Interval, Computed)
/ (< >, Constant)
=centercr
@ []Query Q 4.7.5: Find the budget of the toy department and the time at which Ed worked there.
Answer: ``(2/1/1982 – 1/31/1987, $150K)''
Category: (Projected, Not Empty) /
(Containment, Interval, Computed) /
(=, Constant), (=, Foreign