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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!