GATE CS 2017 (Forenoon) — Question 46

Database Management Systems (DBMS)Relational Models, Relational Algebra, Tuple CalculusNAT2 marksMedium

Consider a database that has the relation schema CR( StudentName, CourseName). An instance of the schema CR is as given below:
Question image
The following query is made on the database. \(T_1 \leftarrow \pi_{\text{CourseName}} (\sigma_{\text{StudentName} = \text{'SA'}} (\text{CR}))\) \(T_2 \leftarrow \text{CR} \div T_1\) The number of rows in \(T_2\) is ________.
Practise the full 2017-FN paper
Challenge a friend: WhatsApp Telegram
From RENYXERAThis week's 10-question challengeSame 10 past-GATE questions for everyone this week — see where you stand.
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