Consider the following table and write relational algebra operations for the following DEPOSIT.
AccNo. |
Name |
Branch |
Amount |
1001 |
Kumar |
Calicut |
10,000 |
1002 |
Salim |
Trivandrum |
25,000 |
1003 |
Fida |
Kottayam |
18,000 |
1004 |
John |
Kannur |
30,000 |
1005 |
Raju |
Thrissur |
5,000 |
1. To display those tuples from DEPOSIT relation where amount is greater than 25,000.
2. To display only AccNo. and Amount to fall depositors.