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?
Corporate default seems to be an event specific to an individual company. Yet despite the apparent diversifiable nature of corporate default (meaning that relatively few bonds would default in a...
Identify each of the following business combinations as being vertical, horizontal, or conglomerate: a. An inboard marine engine company is acquired by an outboard engine manufacturer. b. A cosmetics...
A small printing shop has ten jobs that it must schedule. The processing times and due dates for each job are summarized in the following table. a. Suppose the jobs are scheduled in ascending order...
In this lab, you will: Required: 1. Using Excels Forecast Sheet, forecast future sales for Microsoft. 2. Using Excels Forecast Sheet, forecast future income before extraordinary items for Microsoft....
A cantilever rod is loaded as shown in the figure below. If the tensile yield strength of the material is 300 MPa determine the rod diameter using (a) Maximum principal stress theory (b) Maximum...
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...
A universal coupling is used to connect: (a) Whose axes intersect at a small angle (b) Which are perfectly aligned (c) Which are not aligned (d) Have lateral misalignment
Hey i need the following pages done ASAP.Please and thank you D2L Lesson 1: Electrostatics - Physics X L1Electrostatics X Course Hero +...
Bed & Bath, a retailing company, has two departmentsHardware and Linens. The companys most recent monthly contribution format income statement follows: Department Total Hardware Linens Sales $...
Use the formula g'(a) = lim. [(g(x)-g(a) )/ (x-a) ] x-->a to find g'(x) for g(x) = srqrt(x+7). Find the equation fo the tangrnt line to g(x) at x =-5
As shown in the figure below, an incompressible liquid flows steadily and vertically upward in a circular cross-sectional pipe. At section (1), the velocity profile over the cross-sectional area is...
writE a paper on teamwork 1. Share an experience with working on teamwork during your academic journey or on the job. 2. Share both positive and negative experiences. 3. What are your suggestions...
(a) Find the margin of error for the values of c, s, and n, and (b) Construct the confidence interval for using the t-distribution. Assume the population is normally distributed. c = 0.95, s = 1.1,...
Reread the discussion leading to the result given in (7). Does the matrix sI - A always have an inverse? Discuss.
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)...
Jennifer purchased a home for $1,000,000 in 2016. She paid $200,000 cash and borrowed the remaining $800,000. This is Jennifer's only residence. Assume that in year 2024, when the home had...
business plan describing company with strengths and weaknesses. Any gaps in plan. Recommendations for improvement of the plan.
You wish to buy a car today for $35,000. You plan to put 10% down and finance the rest at 5.20% p.a. for six years. You will make equal monthly payments of $_______.

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