GATEverse Practice, past papers & mock tests
GATE 2025 · session-5
Database Management and WarehousingRelational AlgebramediumNAT2 marks
Consider the following tables of a bank.
Loan numberBranch nameAmount
L11Banjara Hills90000
L14Kondapur50000
L15SR Nagar40000
L22SR Nagar25000
L23Balanagar80000
L25Kondapur70000
L19SR Nagar65000
Customer nameLoan number
AnandL11
KarteekL11
KarteekL14
AnkitaL15
GopalL19
KarteekL22
KarteekL23
SunilL23
SunilL25
Evaluate \[ \pi_{\text{branch name},\,\text{customer name}}(\mathrm{Loan}\bowtie\mathrm{Borrower}) \div \pi_{\text{branch name}}(\mathrm{Loan}), \] where \(\bowtie\) denotes natural join. The number of returned tuples is ______ (answer in integer).
Save your progress

Related Database Management and Warehousing PYQs