Consider the bank database of Figure 3.18, where the primary keys are underlined. Construct the following SQL

Question:

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 branch located in “Brooklyn”.

b. Find the total sum of all loan amounts in the bank.

c. Find the names of all branches that have assets greater than those of at least one branch located in “Brooklyn”.

Figure 3.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 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 insurance database of Figure 3.17, where the primary keys are underlined. Construct the following SQL queries for this relational database. a. Find the number of accidents involving a...
Consider the insurance database of Figure, where the primary keys are underlined. Construct the following QBE queries for this relational-database. a. Find the total number of people who owned cars...
What is the smallest (most negative) 32-bit binary number that can be represented with (a) Unsigned numbers? (b) Twos complement numbers? (c) Sign/magnitude numbers?
Go to the Student website and find the annual report of HMV Group plc. for 2009. Answer the following questions: a. What are the major sections of the annual report? b. What are the three most...
Why would an investor wish to hedge the currency risk in a portfolio of foreign securities? What considerations are relevant to making the decision whether to hedge?
Pallos Company is purchasing the net assets of Shrilly Company. The book and fair values of Shrillys accounts are as follows: Accounts Book Fair Current assets . . . . . . . . . . . . . . . . . . . ....
Sarah Company engaged in the following transactions in July 2010: July 1 Sold merchandise to Chi Dong on credit, terms n/30, FOB shipping point, $2,100 (cost, $1,260). 3 Purchased merchandise on...
S4-6 Calculate a job cost using ABC (Learning Objective 2) Salari Industries, a small, family-run manufacturer, has adopted an ABC system. The fol- lowing manufacturing activities, indirect...
A steel shaft has a diameter of 25 mm. The shaft rotates at a speed of 600 r.p.m. and transmits 30 kW through a gear. The tensile and yield strength of the material of shaft are 650 MPa and 353 MPa...
Write the following queries in SQL, using the university schema. a. Find the ID and name of each student who has taken at least one Comp. Sci. course; make sure there are no duplicate names in the...
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...
Every U.S. president except Ford won a national election. (Ux: x is a U.S. president; Wx: x won a national election; f : Ford) Translate the following statements. Statements involving all except
Research the control system used by your corporation and select pieces of evidence of informational and behavioral control. Be aware that the evidence must respond to the full definition of each type...
What strategies can organizations employ to effectively manage workforce diversity and foster inclusion to leverage the full potential of their human capital in a globalized marketplace ?
You are given an array of integers representing the prices of a stock on different days. Write a function in JavaScript to calculate the maximum profit that can be obtained by buying and selling the...
The following selected information is available for the payroll computations of a company for the month of November 2021: Name of the Employee Gross Payroll for the month Elvira Robles Gloria...
Enter the code (from the Code tab) into your compiler. Compile your code and run it. Answer the following critical thinking questions. Save your answers in a Word document. What happens if you enter...
Find the critical value t c for the level of confidence c and sample size n. c = 0.80, n = 10
For all of the following words, if you move the first letter to the end of the word, and then spell the result backwards, you will get the original word: banana dresser grammar potato revive uneven...
Consider the employee database of Figure. Give expressions in QBE, and Datalog for each of the following queries: a. Find the names of all employees who work for First Bank Corporation. b. Find the...
Consider the relational database of Figure where the primary keys are underlined. Give expressions in QBE for each of the following queries: a. Find all employees who earn more than the average...
Consider the relational database of Figure. Give expressions in QBE for each of the following queries: a. Modify the database so that Jones now lives in Newtown. b. Give all employees of First Bank...
Product Weight Sales Additional Processing Costs P 300,000 lbs. $ 245,000 $ 200,000 Q 100,000 lbs. 30,000 -0- R 100,000 lbs. 175,000 100,000 If joint costs are allocated based on relative weight of...
The projected benefit obligation was $380 million at the beginning of the year. Service cost for the year was $21 million. At the end of the year, pension benefits paid by the trustee were $17...
CVP Modeling project The purpose of this project is to give you experience creating a multiproduct profitability analysis that can be used to determine the effects of changing business conditions on...

Consider the bank database of Figure 3.18, where the primary keys are underlined. Construct the following SQL

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 Find each customer who has an account at every branch located in Brooklyn b Find the total sum ...View the full answer

Database System Concepts

Students also viewed these Computer science questions