Consider the following three relations: Car (model, year, serial, color) Make…

GATE · 2025 · DA · Data Science & AI

Consider the following three relations:

Car (model, year, serial, color)

Make (maker, model)

Own (owner, 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; (owner, serial) together form key for Own. (⋈\bowtie denotes natural join)

πowner(Own⋈(σcolor=“red”(Car⋈(σmaker=“ABC”Make))))\pi_{owner}(Own\bowtie(\sigma_{color=\text{“red”}}(Car\bowtie(\sigma_{maker=\text{“ABC”}}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

Attempted by 14 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…