Question: 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

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 ID of each depositor who has an account with a balance greater than $6000.

c. Find the ID of each depositor who has an account with a balance greater than $6000 at the “Uptown” branch.

Figure 2.18

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

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.37 Rating (163 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a b c ... 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 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...

Consider the bank database of Figure 3.18, where the primary keys are underlined. Construct the following SQL queries for this relational database. a. Find each customer who has an account at every...

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 the name of each branch located in Chicago. b. Find the ID of each...

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

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

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

Rocking Horses Limited produces luxury vintage wooden rocking horses for children. Expected production for this product for January is 3,000 units. Budget information for this product is as follows:...

A memory manager allocates memory in fixed-size chunks of 2048 bytes. The current allocation is as follows: P1:1200 bytes P2: 2047 bytes P3: 1300 bytes P4: 1 byte What is the total amount of memory...

What is the role of standard measures when calculating yeilds and costs for menu items

How could burnout have a good side? What may be a benefit?

Consider the employee database of Figure, where the primary keys are underlined. Give an expression in SQL for each of the following queries. a. Find the names of all employees who work for First...

Consider the relational database of Figure. Give an expression in SQL for each of the following queries. a. Modify the database so that Jones now lives in Newtown. b. Give all employees of First Bank...

Let the following relation schemas be given: R = (A, B, C) S = (D, E, F) Let relations r(R) and s(S) be given. Give an expression in SQL that is equivalent to each of the following queries. a. A(r)...

Use the following data for the next 5 questions: Debt 42,000 bonds with a 5.0% coupon rate, payable annually. 15 years to maturity. selling at $1,050 per bond. Common Stock 739,000 shares of common...

A zero-coupon bond with face value $1,000 and maturity of four years sells for $740.22. a. What is its yield to maturity? (Round your answer to 2 decimal places.) Yield to maturity % b. What will the...

20) The following case pertains to the 2022 tax year. Angelo is employed fulltime as the Head of Human Resources at State Fund Corporation ("State Fund"), a large public corporation with its head...