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

PYQ UGC NET 2022

Read the following data and answer the question.

Consider the relational schema of 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/8/98

22

104

10/7/98

31

102

11/10/98

31

103

11/6/98

31

104

11/12/98

64

101

9/5/98

64

102

9/8/98

74

103

9/8/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/queries computes/compute the name of sailors who have reserved boat 103 ?

Q1: π_sname((σ_bid=103 Boats) ⋈ Sailors)

Q2: π_sname(σ_bid=103(Reserves ⋈ Sailors))

Q3: π_sname((σ_bid=103 Reserves) ⋈ Sailors)

  1. A.

    Both Q1 and Q3

  2. B.

    Both Q2 and Q3

  3. C.

    Only Q3

  4. D.

    Only Q2

Attempted by 177 students.

Sign up free to check your answer

Sign up free

Explore the full course: Nta Ugc Net Paper 2

Loading lesson…