1
GATE AI 2025
Numerical
+2
-0
Consider the following tables, Loan and Borrower, of a bank.
| Loan | ||
| loan_num | branch_name | amount |
| L11 | Banjara Hills | 90000 |
| L14 | Kondapur | 50000 |
| L15 | SR Nagar | 40000 |
| L22 | SR Nagar | 25000 |
| L23 | Balanagar | 80000 |
| L25 | Kondapur | 70000 |
| L19 | SR Nagar | 65000 |
| Borrower | |
| customer_name | loan_num |
| Anand | L11 |
| Karteek | L11 |
| Karteek | L14 |
| Ankita | L15 |
| Gopal | L19 |
| Karteek | L22 |
| Karteek | L23 |
| Sunil | L23 |
| Sunil | L25 |
Query: $\quad \pi_{\text {branch_name, customer_name }}$ (Loan $\triangleright \triangleleft$
Borrower) $\div \pi_{\text {branch_name }}$ (Loan)
where $\triangleright \triangleleft$ denotes natural join.
The number of tuples returned by the above relational algebra query is
__________
Your input ____
GATE Data Science and Artificial Intelligence Subjects
Browse all chapters by subject
General Aptitude
Discrete Mathematics
Artificial Intelligence
Machine Learning
Database Management System and Warehousing
Python Programming
Data Structures