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
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