Answered step by step
Verified Expert Solution
Link Copied!

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

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

Visual Basic 4 Ole Database And Controls Superbible

Authors: Michael Hatmaker, C. Woody Butler, Ibrahim Malluf, Bill Potter

1st Edition

1571690077, 978-1571690074

More Books

Students also viewed these Databases questions

Question

WHAT IS AUTOMATION TESTING?

Answered: 1 week ago

Question

What is Selenium? What are the advantages of Selenium?

Answered: 1 week ago