Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

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_2

Step: 3

blur-text-image_3

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

Advances In Databases And Information Systems Uropean Conference Adbis 2020 Lyon France August 25 27 2020 Proceedings Lncs 12245

Authors: Jerome Darmont ,Boris Novikov ,Robert Wrembel

1st Edition

3030548317, 978-3030548315

More Books

Students also viewed these Databases questions

Question

Find z0 such that P(z > z0) = .5.

Answered: 1 week ago