Databases · Relational Model and SQL
Official IIT answer key · IIT Kharagpur · Audited Aug 2026
GATE CSE 2022 Q25 · MSQ · 1 mark
Key concept
No account needed
Sit 5 related Relational Model and SQLPYQs as a guest. We'll score the set and show which traps cost marks — sign in only if you want to save the run.
Topic notes
GATE tests the relational model across three interrelated formalisms: Relational Algebra (RA), Relational Calculus (TRC/DRC), and SQL. Questions evaluate core semantic equivalences, translation between declarative calculi and algebraic operators, table instance tracing (such as joins, group-by aggregations, and division), and corner cases like SQL three-valued logic, duplicate preservation, and safe TRC expressions.
Full Relational Model and SQL guide →Consider the following three relations in a relational database. Employee( eId, Name), Brand( bId, bName), Own( eId, bId) Which of the following relational algebra expressions return the set of eIds who own all the brands?
Topic-wise GATE CS PYQs with verified steps
Independent practice explanation verified by the GateAI team. GATE is conducted by the IITs; question text follows the official paper.
