Question: Consider the bank database of Figure 2.18. Give an expression in the relational algebra for each of the following queries: a. Find the name of

Consider the bank database of Figure 2.18. Give an expression in the relational algebra for each of the following queries:

a. Find the name of each branch located in “Chicago”.
b. Find the ID of each borrower who has a loan in branch “Downtown”.

branch(branch_name, branch_city, assets) customer (ID, customer_name, customer_street, customer_city) loan (loan_number, branch name,

branch(branch_name, branch_city, assets) customer (ID, customer_name, customer_street, customer_city) loan (loan_number, branch name, amount) borrower (ID, loan_number) account (account number, branch_name, balance) depositor (ID, account_number)

Step by Step Solution

★★★★★

3.49 Rating (166 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a SELECT branchname FROM branch W... View full answer

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 Database System Concepts Questions!

Consider the bank database of Figure 5.21. Let us define a view branch cust as follows: Figure 5.21 Suppose that the view is materialized; that is, the view is computed and stored. Write triggers to...

Consider the employee database of Figure 2.17. Give an expression in the relational algebra to express each of the following queries: a. Find the ID and name of each employee who works for BigBank....

Consider the employee database of Figure 3.19. Give an expression in SQL for each of the following queries. a. Give all employees of First Bank Corporation a 10 percent raise. b. Give all managers of...

2.15 Consider the bank database of Figure 2.18. Give an expression in the relational algebra for each of the following queries: a. Find each loan number with a loan amount greater than $ 10000. b....

Consider the bank database of Figure 2.18. Give an expression in the relational algebra for each of the following queries: a. Find each loan number with a loan amount greater than $10000. b. Find the...

the question is about relational algebra in course could database management system and I don't know how to answer it 11 - 231 -3- - Bb...

Consider the bank database of Figure 2.15. Give an expression in the relational algebra for each of the following queries. a. Find the names of all branches located in Chicago. b. Find the names of...

Activity 3: Consider the bank database of Figure 3.3. Give an expression in the relational algebra for each of the following queries: 1) Find the name of each branch located in "Chicago" 2) Find the...

branch(branch_name, branch_city, assets) customer (customer_name, customer_street, customer_city) loan (loan_number, branch_name, amount) borrower (customer_name, loan_number) account...

Sketch the energy grade line and the hydraulic grade line for the pipeline shown in Figure P4.l.2. Consider all the losses and changes of velocity and pressure heads. Figure P4.l.2 5

Use the Intermediate Value Theorem to show that there is a root of the given equation in the specified interval. 53. x* + x- 3 = 0, (1, 2) 54. In x = x - x, (2, 3) 55. e* = 3- 2x, (0, 1)

1 3 . ( LO 8 ) An auditor decided to confirm accounts payable to accomplish a low level of detection risk for the completeness assertion. Which of the following is the most reasonable sampling plan?...

What is the 3-Rs solution to waste?

Consider the relation of as shown below, which shows the result of the query ?Find the names of all customers who have a loan at the bank.? Rewrite the query to include not only the name, but also...

The outer-join operations extend the natural-join operation so that tuples from the participating relations are not lost in the result of the join. Describe how the theta join operation can be...

Consider the relational database of Figure. Give an expression in the relational algebra for each request: a. Modify the database so that Jones now lives in Newtown. b. Give all employees of First...

The discount rate used in intrinsic valuation reflects the riskiness of company being valued. Describe in your own words how an analyst can assess the riskiness of an industry. Explain in your own...

(a) Differentiate angel investor from venture capital firms. (4 marks) (b) You founded your own company two years ago. Initially you contributed RM200,000 of your own money and in return received 3...

Find global minimum variance Four assets Eir) PG Microsoft BAC Exxon St. Dev. 0.01 0.01 0.01 0.01 0.01 0.2 0.07 0.11 0.07 0.05 Correlations PG Microsoft BAC 0.00490 -0.00065 -0.00065 0.01210 0.00068...