Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please write relational algebra! Customer CUSTOME R_NAME Adams Brooks Curry Glenn Green Hayes Johnson CUSTOMER STREET Spring Senator North Depositor CUSTOMER_N AME Johnson Smith Hayes

image text in transcribed

image text in transcribed

image text in transcribed

Please write relational algebra!

Customer CUSTOME R_NAME Adams Brooks Curry Glenn Green Hayes Johnson CUSTOMER STREET Spring Senator North Depositor CUSTOMER_N AME Johnson Smith Hayes Turner ACCOUNT NUMB ER A-101 A-215 A-102 A-305 Sand Hill Walnut CUSTOME R_CITY Pittsfield Brooklyn Rye Woodside Stamford Harrison Palo Alto Harrison Rye Stamford Princeton Johnson A-201 Jones A-217 Main Alma Lindsay A-222 Main Main Jones Smith Turner Williams Putnam Nassau Account ACCOUN T NUMB LOAN_NUMBE R L-17 ER BALANCE 500 A-101 A-215 A-102 BRANCH_ NAME Downtown Mianus Perryridge Round Hill Perryridge Redwood Brighton L-23 L-15 Borrower CUSTOMER_NA ME Jones Smith Hayes Jackson Curry Smith Williams Adams 700 400 350 A-305 L-14 L-93 900 A-201 A-222 L-11 700 L-17 A-217 750 L-16 Loan LOAN_NU MBER AMOUN T L-17 L-23 1000 2000 Branch BRANCH_N AME Downtown Redwood Perryridge Mianus Round Hill Pownal ASSETS 900000 2100000 BRANCH_NA ME Downtown Redwood Perryridge Downtown Mianus Round Hill Perryridge L-15 1500 L-14 1500 BRANCH CITY Brooklyn Palo Alto Horseneck Horseneck Horseneck Bennington Rye Brooklyn L-93 500 1700000 400200 8000000 400000 3700000 7000000 L-11 900 L-16 1300 North Town Brighton 12 2. Write down the following relational queries from the above tables - a) Find out the account number of the customers whose loan amount is more than 1500. [4] b) Find out the customer street of the customers whose account number is A101 or A215 or A305. [4] c) Find out the branch city of the customer whose account name is Jackson'. [4]

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Machine Learning And Knowledge Discovery In Databases European Conference Ecml Pkdd 2014 Nancy France September 15 19 2014 Proceedings Part I Lnai 8724

Authors: Toon Calders ,Floriana Esposito ,Eyke Hullermeier ,Rosa Meo

2014th Edition

3662448475, 978-3662448472

More Books

Students also viewed these Databases questions

Question

Know the three main dimensions of the service environment.

Answered: 1 week ago

Question

Understand the roles of signs, symbols, and artifacts.

Answered: 1 week ago