Question: 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) 1) 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 2) Find all customers who have an account from at least the Cobb and the Symrna branches 3) Return the name and address of all customers with account balances below $3,000 and that have the word Road on their address. 4) Provide all the customer_ids, names and branch locations for all the distinct accounts each customer might have 2) Draw the syntax tree for ALL the RA expressions you wrote for question #1 (100 points) 3) Based on the syntax trees of question #2

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!