Question: 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

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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

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,...

Suppose we have a database consisting of the following six relations: Branch (branch-name, branch-city, assets) Customer (customer-name, customer-street, customer-city) Loan (loan-number,...

Show how to enforce the constraint an instructor cannot teach two different sections in a semester in the same time slot. using a trigger branch (branch_name, branch_city, assets) customer...

branch(branch_name, branch_city, assets) customer (customer_name, customer_street, customer_city) loan (loan_number, branch_name, amount) borrower (customer_name, loan_number) account...

ANSWER IN SQL branch(branch name, branch_city, assets) customer (customer_name, customer_street, customer_city) loan (loan_number, branch_name, amount) borrower (customer_name, loan_number) account...

Suppose that a B+-tree index on (dept_name, building) is available on relation department. What would be the best way to handle the following selection? (building

Question 4 ( 4 Points ) : Given the following relational database schema ( primary keys are bold and underlined ) . Answer questions 4 . 1 to 4 . 2 : branch ( branch _ id , branch _ name, branch _...

Design sort-based and hash-based algorithms for computing the relational division operation. branch(branch_name, branch_city, assets) customer (customer_name, customer_street, customer_city) loan...

Given the following relational database schema (primary keys are bold and underlined). Answer questions 4.1 to 4.2: branch( branch_id , branch_name, branch_city, assets) customer( customer_id ,...

A company has two factories, one at Liverpool and one at Brighton.[20] In addition it has four depots with storage facilities at Newcastle, Birmingham, London and Exeter. The company sells its...

A manufacturer knows that their items have a normally distributed length, with a mean of 6 inches, and standard deviation of 0.8 inches. If 22 items are chosen at random, what is the probability that...

Agencies of the federal government are not allowed to issue bonds. True False

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

3. Should a major donor receive special privileges, such as a job or college admission for a child?

4. Do you consider yourself a. mostly focused on the future? b. mostly focused on the present? _______

7. Do you like to a. go with the flow? b. make things happen? _______