Consider the bank database of Figure 15.14, where the primary keys are underlined, and the following SQL query: select T.branch name from branch T, branch S where T.assets > S.assets and S.branch city = “Brooklyn” Write an efficient relational-algebra expression that is equivalent to this query. Justify your choice branch(branch_name, branch.city, assets)customer (customer-name, customer-street, customercity)loan (loan_number, branch_name, amount)borrower (customer_name, loan-number)account (account_number, branchname, balance)depositor (customer_name, account_number)Figure 15.14 Bank database.

Explanation: The below expression performs the theta join on the smallest amount of data…

Answered: branch(branch_name, branch.city,…

Principles of Information Systems (MindTap Course List)

13th Edition

ISBN:9781305971776

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter5: Database Systems And Big Data

Section: Chapter Questions

Problem 14SAT

See similar textbooks

Related questions

Question

Consider the bank database of Figure 15.14, where the primary keys are underlined, and the following SQL query:
select T.branch name
from branch T, branch S
where T.assets > S.assets and S.branch city = “Brooklyn”
Write an efficient relational-algebra expression that is equivalent to this query.
Justify your choice

branch(branch_name, branch.city, assets)
customer (customer-name, customer-street, customercity)
loan (loan_number, branch_name, amount)
borrower (customer_name, loan-number)
account (account_number, branchname, balance)
depositor (customer_name, account_number)
Figure 15.14 Bank database.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions