Unformatted text preview:

Relational Algebra HW2Banking Example (primary keys are not indicated)Relational Algebra HW 2Relational Algebra HW2Turn in as a hardcopy at the start of next class period. You may work this assignment in groups.Banking Example (primary keys are not indicated)branch (branch_name, branch_city, assets)customer (customer_name, customer_street, customer_city)account (account_number, branch_name, balance)loan (loan_number, branch_name, amount)depositor (customer_name, account_number)borrower (customer_name, loan_number)Relational Algebra HW 2 Using the Banking relations on the previous slide, develop relational algebra expressions to answer the following queries:1. Find the names of all customers who have a loan at the Perryridge branch.2. Find the names of all customers who have a loan at the Perryridge branch but do not have an account at any branch of the bank.3. Find the name of all customers who have a loan at the bank and the loan amount.4. Find all customers who have an account from at least the ‘Downtown’ and the ‘Uptown’ branches.5. Find all customers who have an account at al l branches located in Brooklyn


View Full Document

UNCA CSCI 343 - Homework

Download Homework
Our administrator received your request to download this document. We will send you the file to your email shortly.
Loading Unlocking...
Login

Join to view Homework and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view Homework 2 2 and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?