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

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

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For book-img-for-question

Database System Concepts

ISBN: 9780078022159

7th Edition

Authors: Abraham Silberschatz, Henry F. Korth, S. Sudarshan

See More Books

Question Posted: Jun 13, 2022 05:05 AM

See More 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...
Which of these is a true statement about silicate minerals? (a) Melting point decreases as silica percentage increases. (b) Melting point increases as silica percentage increases.
How is the statement of earnings related to the three major types of business activities?
AAA reported that the average price of regular gasoline in Pennsylvania was $ 3.65 per gallon. The following data show the price per gallon of regular gasoline for 15 randomly selected stations in...
In each of the following situations, indicate the statistical analysis you would conduct and the appropriate test or test statistic that should be used. a. Respondents in a survey of 1,000 households...
Multiple Choice Questions 1. The moving average inventory cost flow method is applicable to which of the following inventory systems? Periodic Perpetual a. Yes..... Yes b. Yes..... No c. No..... No...
Required information Problem 1-35A (Static) Recording events in a horizontal statements model LO 1-3, 1-4, 1-5, 1-6, 1-7, 1-8, 1-9, 1-10 [The following information applies to the questions displayed...
Your brother has just started a new job as the Controller of an IESBA restricted audit client. You do not serve on the audit engagement. What steps must you take to ensure your independence is not...
Write the following queries in relational algebra, using the university schema. a. Find the ID and name of each instructor in the Physics department. b. Find the ID and name of each instructor in a...
Suppose you are given a relation grade points that provides conversion from letter grades in the takes relation to numeric scores; for example, an A grade could be specified to correspond to 4...
Define a portfolio, and describe how the expected return on a portfolio is computed.
Consider the following information regarding the performance of a money manager in a recent month. The table represents the actual return of each sector of the managers portfolio in column 1, the...
Many countries have national or flagship airlines. The U.S. does not. The following video explains just what a flagship carrier is and why the U.S. cannot claim one. ...
Assume a Brayton refrigeration cycle as shown below with reversible adiabatic compressor and expander. For this cycle the low pressure is 100 kPa and the high pressure is 1.4 MPa with constant...
In Millions May 31, 2020 May 26, 2019 Receivables: Customers $1,648.3 $1,708.5 Less allowance for doubtful accounts (33.2) (28.8) Total $1,615.1 $1,679.7 In Millions May 31, 2020 May 26, 2019...
Do you notice when your favorite restaurant or coffee shop changes the size of its portions? If so, does it impact your purchasing behavior? Why or why not?
A fair six-sided die is rolled. If the number showing is even, you lose a point for each dot showing. If the number showing is odd, you win a point for each dot showing. a. Find E(x) for one roll if...
$10,000 was borrowed at 3.5% on July 17. The borrower repaid $5000 on August 12, and $2000 on September 18. What final payment is required on November 12 to fully repay the loan?
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 selected account balances of Delray Manufacturing for the year ended December 31. (Click on the Graded Worksheet Tab below.) Sales Raw materials inventory, beginning $2,550,000...
The following data are from the accounting records of Niles Castings for year 2 Units produced and sold Total revenues and costs Sales revenue 89,000 $280,000 Direct materials costs 64,000 Direct...
What is Organization culture, site specific example The nature of organization culture, site specific example. Functions of organizational culture, site specific example What are ways to develop and...

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

Question:

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

a b c ...View the full answer

Database System Concepts

Students also viewed these Computer science questions