Monday, 15 May 2023

relational queries

Suppose there is a banking database which comprises following tables :

Customer(Cust_name, Cust_street, Cust_city)

Branch(Branch_name, Branch_city, Assets)

Account (Branch_name, Account_number, Balance)

Loan(Branch_name, Loan_number, Amount)

Depositor(Cust_name, Account_number)

Borrower(Cust_name, Loan_number)  

1.     Find all loans of over $1200

2.    Find the names of all the customers who have taken a loan from the bank and also have an account at the bank.

3.    Find the names of all customers who have a loan, an account, or both, from the bank..

4.    Find the names of all customers who have a loan and an account at bank.

5.    Find the names of all customers who have a loan at the Perryridge branch.

6.    Find the names of all customers who have a loan at the Perryridge branch but do not have an account at any branch of the bank.

7.    Find the names of all customers who have a loan at the Perryridge branch.

8.    Find all customers who have an account from at least theDowntown and the Uptown branches.

 

No comments:

Post a Comment

Timestamp-Based Protocols

Timestamp-Based Protocols Each transaction T i  is issued a timestamp TS( T i ) when it enters the system. •        Each transac...