Saved Bookmarks
| 1. |
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.BorrowerDepositorAcc_NoNameAmountAcc_NoNameAmountAC123juwee50000AC123juwee500AC103Rasheeda25000.AC105Shabana25000AC106Vishnu25000AC116Vishnu125000AC108Aiswarya30000AC108Aiswarya3000(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. |
||||||||||||||||||||||||||||||||
|
Answer» (a)
(b)
(c)
(d)
|
|||||||||||||||||||||||||||||||||