Produce a relation that shows the customer name, account number and balance for all customers at the Wimbledon branch with a balance less than £600.

 

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 Cust-Name R250 Jones B391 Jutley D244 Redley H123 Whalley F213 Bromley Whitehaven R217 Khan Bromley F491 Coupe Southampton D477 Jutley Wimbledon B456 Smith Whitehaven Wimbledon Southampton Branch Wimbledon Southampton 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 Cust-Name R250 Jones B391 Jutley D244 Redley H123 Whalley F213 Bromley Whitehaven R217 Khan Bromley F491 Coupe Southampton D477 Jutley Wimbledon B456 Smith Whitehaven Wimbledon Southampton Branch Wimbledon Southampton 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