[Relational Algebra]
Using the above information, please write relational algebra expressions and display tables to answer the following. Do NOT write in SQL code.
1. Select all staff that happen to be female with a salary more than $20,000
2. List all staff that happen to have a salary between $20,000 and $30,000
Homework Answers
![Q1) Select all staff that happens to be female with a salcy more than $20,000 r o (STAFF)] Sex=FAND salary > 20,000 output:](http://img.homeworklib.com/questions/207701d0-c60f-11ea-a915-3b26d3203167.png?x-oss-process=image/resize,w_560)
If you have doubt comment down.. Also please upvote thanks..
Add Answer to:
[Relational Algebra]
Using the above information, please write relational algebra
expressions and display tables to answer...
Assignment Chapter 6 Part - Assignment Chapter 6 Part 2 - Write Queries that: 1. List...
Assignment Chapter 6 Part - Assignment Chapter 6 Part 2 - Write Queries that: 1. List all Staff first and last names that have a branch number listed the Branch table. 2. Sort the query results from the query above is descending order 3. Join Branch and Staff tables where branch No are equal 4. Execute Left Outer Join for query 3 5. Execute Right Outer Join for query 3. 6. Insert record - 'CR76', 'PL94', '2018-02-28', 'To Big' into...
For the tables given above, write a relational algebra statement to show the names of the...
For the tables given above, write a relational algebra statement to show the names of the female staffs whose salaries are more than 10000. Use S for selection, P for projection, |X| for join, X for cross product, T for aggregation and grouping, U for union, ^ for interaction, / for division, - for intersection. TT T Arial 3 (12pt) T5 - E S @a's For the tables given above, write one relational algebra statement to show the Branch No...
Question 3 (a) Identify the notation A B, and write a brief notes about it. [12...
Question 3 (a) Identify the notation A B, and write a brief notes about it. [12 marks] (b) Do you believe that logical data independence and distribution independence are the backbone for distributed database Explain your position in detail. [13 marks) Question 4 (a) Study the table and show how you can create it from a scratch using MySQL or SQL Server DOB salary branch No staff No Name Name position Sex SL21 John White Manager M SG37 Ann Beach...
The Language Is SQL The language is SQL 13- List full details of agents with first...
The Language Is SQL
The language is SQL
13- List full details of agents with first names having exactly three or four letters sorted by the state attribute. 14- List the first name, the last name, the address, the city, the state, the branch number, and the email of agents working in the branch 8005 and having email addresses from yahoo.com. 15-List the first name, the last name, the address, the city, the state, the branch number, and the email...
Assignment Chapter 6 Part - Assignment Chapter 6 Part 2 - Write Queries that: 1. List all Staff first and last names that have a branch number listed the Branch table. 2. Sort the query results from the query above is descending order 3. Join Branch and Staff tables where branch No are equal 4. Execute Left Outer Join for query 3 5. Execute Right Outer Join for query 3. 6. Insert record - 'CR76', 'PL94', '2018-02-28', 'To Big' into...
For the tables given above, write a relational algebra statement to show the names of the female staffs whose salaries are more than 10000. Use S for selection, P for projection, |X| for join, X for cross product, T for aggregation and grouping, U for union, ^ for interaction, / for division, - for intersection. TT T Arial 3 (12pt) T5 - E S @a's For the tables given above, write one relational algebra statement to show the Branch No...
Question 3 (a) Identify the notation A B, and write a brief notes about it. [12 marks] (b) Do you believe that logical data independence and distribution independence are the backbone for distributed database Explain your position in detail. [13 marks) Question 4 (a) Study the table and show how you can create it from a scratch using MySQL or SQL Server DOB salary branch No staff No Name Name position Sex SL21 John White Manager M SG37 Ann Beach...
The Language Is SQL
The language is SQL
13- List full details of agents with first names having exactly three or four letters sorted by the state attribute. 14- List the first name, the last name, the address, the city, the state, the branch number, and the email of agents working in the branch 8005 and having email addresses from yahoo.com. 15-List the first name, the last name, the address, the city, the state, the branch number, and the email...
Most questions answered within 3 hours.
-
At the start of a CD it is spinning at a rate of 525 rpm
(revolutions...
asked 22 minutes ago -
4. Without doing any calculations, predict whether the observed
∆T would increase, decrease or remain the...
asked 1 hour ago -
Based on the range, which of the following sets of scores has
the greatest variability? 3,...
asked 2 hours ago -
Ripples in a pond travel at a velocity of 3 m/s with one peak
passing a...
asked 2 hours ago -
A man stands on the roof of a building of height 13.0 mm and
throws a...
asked 2 hours ago -
The extent to which assets are financed by borrowed funds and
other liabilities is indicated by:...
asked 3 hours ago -
Explain in detail
Germany is the fifth largest economy
explain what goods and services Germany specializes...
asked 3 hours ago -
The density of platinum is 21.45 g/mL. If a cube of platinum
with a mass of...
asked 4 hours ago -
Accounts Receivable
Sales
A/R Posting
Extended Sales Invoice
Packing Slip
Compare invoice to packing slip 2...
asked 4 hours ago -
Michaella, age 23, is a full-time law student and is claimed by
her parents as a...
asked 4 hours ago -
Why are polymers not typically casted into products?
asked 4 hours ago -
When rolling a die 129 times, what is the probability of rolling
a 6 no more...
asked 4 hours ago