Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started