Write a tuple relational calculus which will list the first

Write a tuple relational calculus which will list the first name and last name of all staff who are managers and work at the branch in London. Also show the result table with tuples. (b) First describe the following relational algebra express and then show the result table. rho_R (myCount) 3_COUNT_staffNo (sigma_sex = \'F\' salary

Solution

1) {<firstname.lastname>|<firstname,lastname> ? Staff ^ Designation=managers^ branch=London}

The tuples can be listed if the database is given

2) Count of all the female staff whoose salary is greater than 20000.

Again to show the tuples database should be given

3) Database should be given