The Sailors-Boats-Reserves database schema consists of three relations, whose schemas are: Sailors(sid, sname, rating, age) Boats(bid, bname, color) Reserves(sid, bid, day) Sailors Boats Reserves sid sname rating age bid bname color sid bid day 22 Dustin 45 101 Interlake blue 22 101 2020-10-10 29 Brutus 1 33 102 Interlakered 22 102 2020-10-10 31 Lubber 18 55.5 |103 Clipper Igreen 22 103 2020-10-8 32 Andy 8 25.5 104 Marine red 22 104 2020-10-7 58 Rusty 10 35 31 102 2020-11-10 64 Horatio 7 35 31 103 2020-11-6 71 Zorba 10 16 31 104 2020-11-12 74 Horatio 19 40 64 101 2020-9-5 85 Art 3 25.5 64 102 2020-9-8 95 Bob 63.5 74 103 2020-9-8 Figure 1: Instances of Sailors, Boats and Reserves Give a relational algebra expression for each of the following queries: Find all information of sailors wh have reserved boat number 102.

Elements Of Modern Algebra
8th Edition
ISBN:9781285463230
Author:Gilbert, Linda, Jimmie
Publisher:Gilbert, Linda, Jimmie
Chapter1: Fundamentals
Section1.7: Relations
Problem 20E: Give an example of a relation R on a nonempty set A that is symmetric and transitive, but not...
icon
Related questions
Topic Video
Question

Relational algebra questions

The Sailors-Boats-Reserves database schema
consists of three relations, whose schemas are:
Sailors(sid, sname, rating, age)
Boats(bid, bname, color)
Reserves(sid, bid, day)
Sailors
Вoats
Reserves
sid
sname
rating age
bid bname
color
sid bid day
22
Dustin
7
45
|101 Interlake blue
22 |101 2020-10-10
29
Brutus
1
33
102 Interlake red
22 102 2020-10-10
31
Lubber
8
55.5
|103 Clipper Igreen 22 103 2020-10-8
32
Andy
25.5
104 Marine
red
22 104 2020-10-7
58
Rusty
10
35
31 102 2020-11-10
64
Horatio
7
35
31 103 2020-11-6
71
Zorba
10
16
31 104 2020-11-12
74
Horatio
9
40
64 101 2020-9-5
85
Art
3
25.5
64 102 2020-9-8
95
Bob
63.5
74 103 2020-9-8
Figure 1: Instances of Sailors, Boats and
Reserves
Give a relational algebra expression for each of
the following queries:
Find all information of sailors who
have reserved boat number 102.
Transcribed Image Text:The Sailors-Boats-Reserves database schema consists of three relations, whose schemas are: Sailors(sid, sname, rating, age) Boats(bid, bname, color) Reserves(sid, bid, day) Sailors Вoats Reserves sid sname rating age bid bname color sid bid day 22 Dustin 7 45 |101 Interlake blue 22 |101 2020-10-10 29 Brutus 1 33 102 Interlake red 22 102 2020-10-10 31 Lubber 8 55.5 |103 Clipper Igreen 22 103 2020-10-8 32 Andy 25.5 104 Marine red 22 104 2020-10-7 58 Rusty 10 35 31 102 2020-11-10 64 Horatio 7 35 31 103 2020-11-6 71 Zorba 10 16 31 104 2020-11-12 74 Horatio 9 40 64 101 2020-9-5 85 Art 3 25.5 64 102 2020-9-8 95 Bob 63.5 74 103 2020-9-8 Figure 1: Instances of Sailors, Boats and Reserves Give a relational algebra expression for each of the following queries: Find all information of sailors who have reserved boat number 102.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Propositional Calculus
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, geometry and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Elements Of Modern Algebra
Elements Of Modern Algebra
Algebra
ISBN:
9781285463230
Author:
Gilbert, Linda, Jimmie
Publisher:
Cengage Learning,