Produce a relation that shows the following information: customer name, balance and account number for all customers that have a loan bigger than £1000.00 AND all customers that have a deposit account with a balance smaller than £1000.00. All customers should be at the Wimbledon branch.

 

Transcribed Image Text:

The relational schema shown below is part of a banking system. The contents of the Deposit and Branch tables are also shown below. Deposit (Branch, Acc-No, Cust-Name, Balance) Loan (Branch, Loan-No, Cust-Name, Balance) Branch (Branch, Assets, Branch-County) Customer (Cust-Name, Cust-County, Branch) Table: Employee Deposit Branch Acc-No Whitehaven R250 Jones Wimbledon B391 Jutley Southampton 0244 H123 Whalley F213 R217 Khan F491 Coupe Southampton D477 Jutley Wimbledon B456 Smith Redley Bromley Whitehaven Bromley Branch Wimbledon Southampton Cust-Name Redley Bromley Whitehaven Stephenson Choudhury Balance 800.00 650.89 500.00 88.90 580.35 77.50 350.00 375.44 200.00 Branch-County Lancashire Assets 1,000,000 2,000,250 1,500,500 Warwickshire 1,750,001 Warwickshire 2,000,101 Birmingham Northamptonshire The relational schema shown below is part of a banking system. The contents of the Deposit and Branch tables are also shown below. Deposit (Branch, Acc-No, Cust-Name, Balance) Loan (Branch, Loan-No, Cust-Name, Balance) Branch (Branch, Assets, Branch-County) Customer (Cust-Name, Cust-County, Branch) Table: Employee Deposit Branch Acc-No Whitehaven R250 Jones Wimbledon B391 Jutley Southampton 0244 H123 Whalley F213 R217 Khan F491 Coupe Southampton D477 Jutley Wimbledon B456 Smith Redley Bromley Whitehaven Bromley Branch Wimbledon Southampton Cust-Name Redley Bromley Whitehaven Stephenson Choudhury Balance 800.00 650.89 500.00 88.90 580.35 77.50 350.00 375.44 200.00 Branch-County Lancashire Assets 1,000,000 2,000,250 1,500,500 Warwickshire 1,750,001 Warwickshire 2,000,101 Birmingham Northamptonshire

Answer rating: 100% (QA)

The following SQL query will produce a relation that shows the customer name ... View the full answer