Question: Use the following relations to answer the questions below using relational calculus. All questions must be answered with tuple relation calculus. Branch branchNo street city
Use the following relations to answer the questions below using relational calculus.
All questions must be answered with tuple relation calculus.
Branch
| branchNo | street | city | postcode |
| B005 | 22 Deer Rd | London | SW1 4EW |
| B007 | 16 Argyll St | Aberdeen | AB2 3SU |
| B003 | 163 Main St | Glasgow | G11 9QX |
| B004 | 32 Manse Rd | Bristol | BS99 1NZ |
| B002 | 56 Clover Dr | London | NW10 6EU |
Staff
| staffNo | fName | lName | position | sex | DOB | salary | branchNo |
| SL21 | John | White | Manager | M | 1-Oct-45 | 30000 | B005 |
| SG37 | Ann | Beech | Assistant | F | 10-Nov-60 | 12000 | B003 |
| SG14 | David | Ford | Supervisor | M | 24-Mar-58 | 18000 | B003 |
| SA9 | Mary | Howe | Assistant | F | 19-Feb-70 | 9000 | B007 |
| SG5 | Susan | Brand | Manager | F | 3-Jun-40 | 24000 | B003 |
| SL41 | Julie | Lee | Assistant | F | 13-Jun-65 | 9000 | B005 |
1. Give a relational calculus statement that returns first and last names of all staff and which city they work in.
2. Give a relational calculus statement that returns the first and last name of all the employees that work in Glasgow but isnt the Manager.
3. Give a relational calculus statement that returns the branchNo, street, and city of all branches that have no staff working at it.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
