Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1) Write Relational Algebra expressions AND the corresponding SQL for the following queries (100 points for the RA expressions, 100 points for the SQL queries):
1) Write Relational Algebra expressions AND the corresponding SQL for the following queries (100 points for the RA expressions, 100 points for the SQL queries): Relations: Customers(customer_id, name, address) Accounts(account_id, customer_id, branch_id, balance) Branches(branch_id, location, county, address, year_founded) Add 2% interest to accounts with a balance less than $8,000, and 1.5% interest to accounts with a balance of $10,000 or more Find all customers who have an account from at least the "Cobb" and the "Symrna" branches Return the name and address of all customers with account balances below $3,000 and that have the word 'Road' on their address. Provide all the customer_ids, names and branch locations for all the distinct accounts each customer might have 1) 2) 3) 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