Answered step by step
Verified Expert Solution
Question
1 Approved Answer
2. 5 a) Consider a banking database with the following relation schemas: branch (branch_name, branch_city, assets) customer (customer_name, customer_street, customer_city) account (account_number, branch_name, balance) loan
2. 5 a) Consider a banking database with the following relation schemas: 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) Use relation algebra and SQL to write the following queries: i. Find all loans of over $1200 at the Perryridge branch. ii. Find the names of all customers who meet the following criteria: A. They are both a borrower and depositor. B. Both their loan and balance are over $1200. a
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