Question: Use the following relations to answer the questions below using relational algebra. Branch branchNo street city postcode B005 22 Deer Rd London SW1 4EW B007

Use the following relations to answer the questions below using relational algebra.

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

2. Give the relational algebra statement that returns a count of how many staff work in each city. Also give the relation that will be the output of your statement.

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!

Q:

Use the following relations to answer the questions below using relational algebra. Branch branchNo street city postcode B005 22 Deer Rd London SW1 4EW B007 16 Argyll St Aberdeen AB2 3SU B003 163...

Q:

Use the following relations to answer the questions below using relational algebra. Branch branchNo street city postcode B005 22 Deer Rd London SW1 4EW B007 16 Argyll St Aberdeen AB2 3SU B003 163...

Q:

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...

Q:

3. Show the result of a Cartesian-product operation applied to Branch and Registration relations. (20 points) Branch x Registration 4. Show the result of a natural join of the Branch and Registration...

Q:

3. a) A query displays staff last names, the number of viewings made by them, and the last date of their showing. Give the relational algebra notation for this. b) Write the Create View statement to...

Q:

write a query to display the city of a branch and the number of staff members work in the branch whose position is not manager Branch(branchNo, street, city, postcode) Staff(staffNo, fname, Iname,...

Q:

deletion/update anomalies question Consider the Branch (with primary key: branchNo) and Staff (with primary key: staffNo & foreign key: branch No) tables shown below and answer the following...

Q:

Write a sql query to display the branch numbers and the number of properties managed by each branch ch. 112 Chapter 4 The Relational Model Figure 4-3 Instance of the Dream Home rental database SWI...

Q:

3. Write a query to list the client numbers and total numbers of properties that match the client preferred type. 112 Chapter 4 The Relational Model Figure 4-3 Instance of the Dream Home rental...

Q:

Write a query to list the client names, client phone numbers and the dates they registered. 112 Chapter 4 The Relational Model Figure 4-3 Instance of the Dream Home rental database SWI GEH Branch...

Q:

Solve each of the following pairs of equations to three-figure accuracy. 2v+6w=1 -9w + 10v = 18

Q:

Find the values of S and Z and the shape factor about the horizontal x axes, for the sections shown in the accompanying figures. 8-10. 8-2. 2in 72 2 in =in 18 in II 14 in 2 in 6 in || FIGURE P8-2 int...

Q:

If quoted exchange rates are the same across different locabions, then q , is noe ferasible. triangular arbitrage covered interest arbitrage locasional arbitrage A and C

Q:

Give ONE example from each of the dimensions of the business environment of a power-generating company represented by the acronym STEEPLE....

Q:

7. Go to www.5off5on.com, the Web site for Pit Instruction and Training, a company that provides training for racing pit crews as well as team training. Enter the site. Click on Lean Performance U...

Q:

2. Go to www.sabrehq.com, the Web site for Sabre Corporate Development. Click on Team Building Events. Choose one of the activities and events found on this page, and review it. Discuss what you...

Q:

4. Review one of the following Web sites, which feature simulations: www.incomeoutcome. com or www.celemi.com. Describe the situation that the simulation is designed to represent. What elements in...