LIVE Course for free

Rated by 1 million+ students
Get app now
0 votes
in Database Management System by (32.5k points)
closed by

Consider the following table arid write relational algebra operations for the following DEPOSIT.

AccNo Name Branch Amount
1001 kumar Calicut 10,0000
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 of all depositors

1 Answer

+1 vote
by (32.9k points)
selected by
Best answer

πamount> 25000 (Deposit)

σAccNo, amount (deposit)

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.