Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
227 views
in Database Management System by (30.5k points)
closed by

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.

1 Answer

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

1. σamount >25000 (Deposit) 

2. π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.

...