=centercr
@ []Query Q 4.5.1: List the names and ages of all employees at the time they received
their first salary increment.
Answer: ``(Ed, 26 years & 11 months), (Di, 23 years & 10 months)''
Category: (Projected, Interval, Derived) / (Containment, Event, Computed) /
=centercr
@ []Query Q 4.5.2: List the names and salary histories of all female employees as of
their 25th birthday.
Answer: ``(Di, (30K, 01/01/82–07/31/84), (40K, 08/01/84–10/01/85))''
Category: (Projected, Element, Derived) / (Containment, Event, Computed) (Duration, Interval, explicit) / (=, Constant)
=centercr
@ []Query Q 4.5.3: When and who ever changed their names?
Answer: ``(Ed, 01/01/88)''
Category: (Projected, Event, Derived) / (Containment, Event, Computed) /
=centercr
@ []Query Q 4.5.4: How old was Ed and what skills did he have at the time he changed his
name to Edward?
Answer: ``(32 years & 6 months, {Driving, Filing, Typing})''
Category: (Projected, Interval, Derived) / (Containment, Event, Computed) / (=, Constant)
(=, Constant)
=centercr
@ []Query Q 4.5.5: When did Ed acquire driving skills and what other skills did he have
at the time?
Answer: ``(01/01/82, None), (06/01/84, Typing)''
Category: (Projected, Event, Derived) / (Containment, Event, Computed) / (=, Constant)
(=, Constant)
=centercr
@ []Query Q 4.5.6: Who and when was the first female manager of the Toy department?
Answer: ``(Di, 01/01/82)''
Category: (Projected, Event, Derived) / (Containment, Event, Computed) (temporal aggregate) / (=, Constant) (=, Constant)