Consider the instance of the BORROWER and DE- POSlTOR relations shown in following figure which stores the details of customers in a Bank. Answer the following queries in relational algebra.
(a) Display the details of the customers who are either a depositor or a borrower.
Borrower |
Depositor |
Acc_No |
Name |
Amount |
Acc_No |
Name |
Amount |
AC123 |
juwee |
50000 |
AC123 |
juwee |
500 |
AC103 |
Rasheeda |
25000. |
AC105 |
Shabana |
25000 |
AC106 |
Vishnu |
25000 |
AC116 |
Vishnu |
125000 |
AC108 |
Aiswarya |
30000 |
AC108 |
Aiswarya |
3000 |
(b) Display the name of customers who are both a depositor and a borrower.
(c) Display the details of the customers who are d positors but not borrowers.
(d) Display the name and’amount of customer who is a borrower but not depositor.