Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

 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.

 

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

The following SQL query will produce a relation that s... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

More Books

Students also viewed these Databases questions