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. ( denotes natural join)
Which one of the following options describes what the above expression computes?
- A.
All owners of a red car, a car made by ABC, or a red car made by ABC
- B.
All owners of more than one car, where at least one car is red and made by ABC
- C.
All owners of a red car made by ABC
- D.
All red cars made by ABC
Attempted by 14 students.
Sign up free to check your answer
Sign up freeLoading lesson…