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

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

I need this within 20min. Urgent

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!

Q:

Recall the previous exercise, which described the Italian firm Ma-Vib that was in the news for sexual discrimination for having chosen only its female employees to be dismissed. Before the layoff s,...

Q:

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

Q:

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

Q:

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

Q:

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

Q:

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

Q:

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

Q:

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

Q:

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

Q:

Module 1 Assignment 2 - Relational Model Overview This assignment is based on the following bank database. branch ( branch _ name, branch _ city, assets ) customer ( ID , customer _ name, customer _...

Q:

This assignment is based on the following bank database. branch ( branch _ name, branch _ city, assets ) customer ( ID , customer _ name, customer _ street, customer _ city ) loan ( loan _ number,...

Q:

The circuit shown in Fig. 5-32 (P5.3) uses two identical springs to support a 10-cm-long horizontal wire with a mass of 20 g. In the absence of a magnetic field, the weight of the wire causes the...

Q:

In its proposed 2010 income statement, Supply Corporation reports income before income taxes $500,000, extraordinary loss due to earthquake $150,000, income taxes $200,000 (not including irregular...

Q:

3 2 Esory 5 points There are three ( 3 ) targeting strategies discussed in your text. Briefly describe each and provide an example.

Q:

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Q:

14-5 How much does project management impact the success of a new information system?

Q:

14-8 The U.S. Census launched an IT project to arm its census takers in the field with high-tech handheld devices that would save taxpayer money by directly beaming population data to headquarters...

Q:

14-10 This project provides you with an opportunity to use spreadsheet software to use the capital budgeting models discussed in this chapter and its Learning Tracks to analyze the return on an...