GATE CS 2021 (Forenoon) — Question 33

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

A relation \(r(A, B)\) in a relational database has 1200 tuples. The attribute \(A\) has integer values ranging from 6 to 20, and the attribute \(B\) has integer values ranging from 1 to 20. Assume that the attributes \(A\) and \(B\) are independently distributed. The estimated number of tuples in the output of \(\sigma_{(A > 10) \lor (B = 18)}(r)\) is _________.
Practise the full 2021-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