GATE DA 2025 — Question 17

Database Management and Warehousingrelational model: relational algebra, tuple calculus, SQLMCQ1 mark · −1/3 if wrongEasy

Consider the following three relations: Car (model, year, \(\underline{\text{serial}}\), color) Make (maker, \(\underline{\text{model}}\)) Own (\(\underline{\text{owner}}\), \(\underline{\text{serial}}\)) A tuple in Car represents a specific car of a given model, made in a given year, with a serial number and a color. A tuple in Make specifies that a maker company makes cars of a certain model. A tuple in Own specifies that an owner owns the car with a given serial number. Keys are underlined; (\(\underline{\text{owner}}\), \(\underline{\text{serial}}\)) together form key for Own. (\(\bowtie\) denotes natural join)
\[\pi_{\text{owner}}(\text{Own} \bowtie (\sigma_{\text{color}=\text{“red”}}(\text{Car} \bowtie (\sigma_{\text{maker}=\text{“ABC”}}\text{Make}))))\]
Which one of the following options describes what the above expression computes?
  1. A
    All owners of a red car, a car made by ABC, or a red car made by ABC
  2. B
    All owners of more than one car, where at least one car is red and made by ABC
  3. C
    All owners of a red car made by ABC
  4. D
    All red cars made by ABC
Practise the full 2025 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 model: relational algebra, tuple calculus, SQLTimed, 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