GATE CS 2024 (Forenoon) — Question 35

Database Management Systems (DBMS)Relational Models, Relational Algebra, Tuple CalculusNAT1 markMedium

Consider the following two relations, \( R(A, B) \) and \( S(A, C) \):
Question image
Question image
The total number of tuples obtained by evaluating the following expression
\[ \sigma_{B < C}(R \bowtie_{R.A = S.A} S) \]
is ________.
Practise the full 2024-FN paper
Challenge a friend: WhatsApp Telegram
Recommended book · affiliate linkDatabase System Concepts (Korth)Normalisation, SQL, transactions and indexing — the DBMS syllabus in one book.
Practise more on Relational Models, Relational Algebra, Tuple CalculusTimed, in the real exam interface · free to start

A GATE question every morning

One real past-paper question every morning for your branch, answer hidden until you tap. Free on Telegram.

Join
Stuck? Ask in the student group