Question: 2. Consider the bank database, where the primary keys are underlined Construct the following SQL queries for this relational database. branch(branch name, branch city, assets)

2. Consider the bank database, where the primary keys are underlined

2. Consider the bank database, where the primary keys are underlined Construct the following SQL queries for this relational database. 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 (account number, branch name, balance) depositor (customer name account number) a. Find all customers who have an account at all the branches located in "Brooklyn" b. Find out 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

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 Databases Questions!

1. Assume the following table- Degree (degcode, name, subject) Candidate (seatno, degcode, name, semester, month, year, result) Marks (seatno, degcode, semester, month, year, papcode, marks) [degcode...

employee (ID, person name, street, city) works (ID, company_name, salary) company (company name, city) manages ( ID, manager id) Consider the above relational database, where the primary keys are...

The Trade Master company sells various tools. It has sales offices and warehouses all over Australia. The company developed a data warehouse to store information about sales, customers and products....

2A. Consider the Bank Database schema: branch (branch name string, branch city: string, assets: real) account (account mumber integer, branch name: string, balance: real) depositor (customer name:...

Consider the bank database. branch(branch name, branch city, assets) customer (customer name, customer street, customer city) loan (loan number, branch name, amount) borrower (customer name, loan...

use relational algebra Consider the bank database given below: branch (branch name, branch_city, assets) customer (customer_name, customer_street, customer_city) account (account number, branch_...

What is the difference between an exempt and a nonexempt employee?

1. What forms of homeowners insurance are available? Which forms should the Salazars consider? 2. What are the perils against which the home and its contents should be insured? 3. Discuss the types...

a fixed repurchase strategy multiple choice allows managers to repurchase shares only when they believe those shares are undervalued

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

3. Are certain kinds or types of jobs better for job sharing? Do the characteristics of the job, the manager, or the employees sharing the job have the most important influence on the effectiveness...

1. From a careers perspective, why would two employees decide to job share?

2. What are the advantages and disadvantages of job sharing from the companys perspective?