1.

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

Answer»

1. σamount >25000 (Deposit) 

2. πAccNo, amount (deposit)



Discussion

No Comment Found