Question: Consider the relational database as given below, where the primary keys are underlined. branch(branch _ name, branch_city, assets) customer (customer _name customer_street, customer_city) loan (loan

Consider the relational database as given below, where the primary keys are underlined. branch(branch _ name, branch_city, assets) customer (customer _name customer_street, customer_city) loan (loan _number, branch _name, amount) berrower (customer name, loan _number) account (account number, branch_name, balance) depositor (customer name, account number) Give an expression in the relational algebra to express each of the following queries. 1. Find the names of the customer who do not have either account or loan at the bank. 2.Find the names of the customers who have only loan or only account at the bank. 3. Find the branch where "Smith" have an account. 4.Find the city of the customer who hold the loan number "L-11". 5.Find the customers who have account balance greater than 2500/-

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!

Database task Q1: Consider the following SELECT-FROM-WHERE statement. SELECT movie Title FROM Starsin, Movie Star WHERE starName = name AND birthdate = 1960; It can be translated into Relational...

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

Consider the following bank database. Assume that branch names and customer names uniquely identify branches and customers, but loans and accounts can be associated with more than one customer....

Database Schema: branch ( branch_name , branch_city, assets ) customer ( cust_ID , customer_name, customer_street, customer_city ) loan ( loan_number , branch_name, amount ) borrower ( cust_ID ,...

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

Consider the bank database of Figure 3.18, where the primary keys are underlined. Construct the following SQL queries for this relational database. a. Find each customer who has an account at every...

Write a query to find each customer who has an account at every branch located in Brooklyn Consider the bank database schema given below, where the primary keys are underlined. Write the SQL DDL...

How do changes in minimum wage can affect higher-paid employees as well.

As part of your first audit of the financial statements of Marina del Rey, Inc., you have decided to confirm some of the accounts payable. You are now in the process of selecting the individual...

Which is the best financial statement to examine to assess a company's liquidity position? Statement of comprehensive income. Income statement. Balance sheet. Cash flow statement.

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

1. Compare and contrast any two of the following learning theories: expectancy theory, social learning theory, reinforcement theory, information processing theory.

3. What value would it be to know that you were going to be training a class of persons between the ages of 20 and 35? Would it influence the approach you would take? How?

5. How do instructional objectives help learning to occur?