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...
The following two samples were collected as matched pairs: a. State the null and alternative hypotheses to test if the population represented by Sample 1 has a mean that is 2.0 units higher than the...
What is the difference between null and alternative hypothesis?
How does deferred or unearned revenue arise? Why can it be classified properly as a current liability? Give several examples of business activities that result in unearned revenues.
At the end of May, the sales journal of Mountain View appears as follows. Assume beginning inventory balance for May to be $8,572. Sales Journal Accounts Receivable Debit Invoice Date May 6 Account...
Consider the extended LAN connected using bridges B1 and B2 in Fig. 4-41(b). Suppose the hash tables in the two bridges are empty. List all ports on which a packet will be forwarded for the following...
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...
Air at 27C and a velocity of 5 m/s passes over the small region As (20 mm x 20 mm) on a large surface, which is maintained at Ts = 127C. For these conditions, 0.5 W is removed from the surface As. In...
3. Consider the following pseudo-code in an imperative language: int x = 1, n = 1; function f () { int x = 3; function g (int c,d) { c = c-1; print (c,d,x,n); } /* end of g */ /* body of f */ g(x,x);...
What is the output of this C program? Explain. #include int main(void) { char x = 100; double y = 3.1415926; char *p = &x; double *q=&y; printf("p is %d, q is %d.", sizeof(p), sizeof(q)); return 0;
4. Suppose that a hard disk's heads are at cylinder 50 and requests have been queued for the following cylinders: 1, 57, 46, 104, 18, 60, 93, 32, 112. a. Give the order and the total number cylinders...
79. Prove that if p is a prime number and r is an integer with () 0
What is the complexity of given code segment below? public static void whoknows(int[][] arr) { for (int i = 0; i < arr.length; i++) { for (int j = 0; j
Bonny and Sally are playing in a tennis tournament. On average, Bonny makes 80% of her shots, whereas Sally makes 75% of hers. Bonny serves first. At right are tree diagrams depicting possible...
Access the Federation of Tax Administrators Internet site at www. taxadmin.org/state-tax-forms and indicate the titles of the following state tax forms and publications: a. Minnesota Form M-100 b....
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...
Angela Lopez owns and manages a consulting firm called Metrix, which began operations on December 1. On December 31, Metrix shows the following selected accounts and amounts for the month of...
The spot EURSAR rate is 3 , 6 8 , the 6 months euro interest rate is 1 , 8 0 % and the 6 months Riyal rate is 4 % . The 6 months forward rate must quote at?
need your assistance with my assignment. Theoretical framework and conceptual framework of Organizational culture on Facebook. Industry comparison is Twitter Critical analysis of Facebook's...

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