Question: Write the following queries in SQL language using the relational database given below. branch (branch-name, branch-city, assets) customer (ID, customer-name, customer-neighborhood, customer-city) credit (credit-number, branch-name,

Write the following queries in SQL language using the relational database given below. branch (branch-name, branch-city, assets) customer (ID, customer-name, customer-neighborhood, customer-city) credit (credit-number, branch-name, amount) borrower (identification, credit-number) deposit (account-number, branch-name, balance) depositor (ID, account-number) a) Which customers have both a debt loan at Lefke branch and a deposit account at Gemikona branch? b) How many customers have a deposit account of more than 10,000 lira at the Lefke branch? c) Which depositor has the highest account balance? d) List the total number of deposit accounts and total debt loans for each branch of the bank. e) For each branch of the bank, list the highest depository and lowest debt loan holder.

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!

Module 1 Assignment 2 - Relational Model Overview This assignment is based on the following bank database. branch ( branch _ name, branch _ city, assets ) customer ( ID , customer _ name, customer _...

This assignment is based on the following bank database. branch ( branch _ name, branch _ city, assets ) customer ( ID , customer _ name, customer _ street, customer _ city ) loan ( loan _ number,...

PART 1 Banking Database Design Banking DDL: Consider the bank database schema given below. Write the SQL DDL corresponding to this schema ( i . e . the CREATE TABLE statements ) . When you are...

he banking schema is provided in the file make-banking.sql. For reference, here is the banking database schema: branch (branch_name, branch_city, assets) customer (customer_name, customer_street,...

The first part requires a ER Diagram ERD Problem (30 points) A database needs to be developed for an apartment rental agency in a big city. The agency rents out properties to tenants on behalf of the...

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

Problem 2 (Part a is 2 points, parts b-c are 3 points each; total is 8 points) Write SQL statements that define the following views. Make sure that all columns in each view's results have meaningful...

Write a query to find each customer who has an account at every branch located in Brooklyn Consider the bank database schema given below, where the primary keys are underlined. Write the SQL DDL...

A child attaches a toy car to a bunch of balloons. The child releases the toy car at ground level. Assume the toy car has a constant acceleration of 0.400 m/s and air resistance is 2 negligible....

Exmouth Pty Ltd bought the following - A bobcat on the 1st July 2018 for $60,000. A large hydro Press for $10,000. A further installation cost amounted to $5000. The whole amount was paid on the 1st...

If the pre - adjustment trial balance of a sole proprictorship includes R 1 0 0 0 0 in prepaid insurance and no adjustment is made by year - end, net income will be overstated. True False

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. Did you seek anyones advice?

7. What traps should she avoid?

5. What decision-making model would you advocate to this person?