Question

For the tables given above, write a relational algebra statement to show the names of the female staffs whose salaries are more than 10000. Use S for selection, P for projection, |X| for join, X for cross product, T for aggregation and grouping, U for union, ^ for interaction, / for division, - for intersection. TT T Arial 3 (12pt) T5 - E S @a's

Answer 1

Please find the relational algebra below.

P(fName, lName) (S(salary > 10000 and sec = 'F') Staff);