Read the following and answer the question. Consider the relational schema…

UGC NET 2022

Read the following and answer the question.

Consider the relational schema Sailors S, Reserves R and Boats B.

Table 1: Sailors S
Sid | Sname   | Rating | Age
22  | Dustin  | 7      | 45.0
29  | Brutus  | 1      | 33.0
31  | Lubber  | 8      | 55.5
32  | Andy    | 8      | 25.5
58  | Rusty   | 10     | 35.0
64  | Horatio | 7      | 35.0
71  | Zorba   | 10     | 16.0
74  | Horatio | 9      | 35.0
85  | Art     | 3      | 25.5
95  | Bob     | 3      | 63.5

Table 2: Reserves R
Sid | Bid | Day
22  | 101 | 10/10/98
22  | 102 | 10/10/98
22  | 103 | 10/08/98
22  | 104 | 10/07/98
31  | 102 | 11/10/98
31  | 103 | 11/06/98
31  | 104 | 11/12/98
64  | 101 | 09/05/98
64  | 102 | 09/08/98
74  | 103 | 09/08/98

Table 3: Boats B
Bid | Bname     | Color
101 | Interlake | blue
102 | Interlake | red
103 | Clipper   | green
104 | Marine    | red

Which of the following relational algebra query computes the sid values of sailors with age > 20 who have not reserved a red boat?

  1. A.

    π_sid(σ_age > 20(Sailors)) − π_sid((σ_color = 'red'(Boats)) ⋈ Reserves ⋈ Sailors)

  2. B.

    π_sid(σ_color ≠ 'red' ∧ age > 20(Boats ⋈ Sailors ⋈ Reserves))

  3. C.

    π_sid(σ_age < 20(Sailors)) − π_sid((σ_color = 'red'(Boats)) ⋈ Reserves ⋈ Sailors)

  4. D.

    π_sid(σ_age > 20(Sailors)) ∩ π_sid((σ_color = 'red'(Boats)) ⋈ Reserves ⋈ Sailors)

Attempted by 176 students.

Sign up free to check your answer

Sign up free

Explore the full course: Uppsc Polytechnic Lecturer 2025 Cs

Loading lesson…