Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using the staff and Branch relations for the database used in class, write relational algebra queries for the following: Branch branchNo street city postcode B005

image text in transcribed

Using the staff and Branch relations for the database used in class, write relational algebra queries for the following:

Branch branchNo street city postcode B005 1007 1003 1004 B002 22 Deer Rd London SW1 4EH 16 Argyll St Aberdeen AB2 3SU 163 Main St Glasgow G11 90X 32 Manse Rd Bristol BS99 INZ 56 Clover Dr London NW10 6EU Staff staffNo Name Name position sex | DOB salary branch No SL21 John White Manager M 1-Oct-45 30000 BOOS SG37 Ann Beech Assistant F 10-Nov-60 12000 B003 SG14 David Ford Supervisor M 24-Mar-5818000 B003 SA9 Mary Howe Assistant F 19-Feb-70 9000 B007 SGS Susan Brand Manager F 3-Jun-40 24000 2003 SL41 Julie Lee Assistant F 13-Jun-65 9000 B005 3. Using the staff and Branch relations for the database used in class, write relational algebra queries for the following: a. List the street, city and postcode of all female staff. b. List the cities of all staff born before 1955. C. List all branch details for all staff who are managers

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

AutoCAD Database Connectivity

Authors: Scott McFarlane

1st Edition

0766816400, 978-0766816404

More Books

Students also viewed these Databases questions

Question

Explain all drawbacks of application procedure.

Answered: 1 week ago

Question

Explain the testing process of accounting 2?

Answered: 1 week ago