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.

Elementary Geometry For College Students, 7e
7th Edition
ISBN:9781337614085
Author:Alexander, Daniel C.; Koeberlein, Geralyn M.
Publisher:Alexander, Daniel C.; Koeberlein, Geralyn M.
ChapterP: Preliminary Concepts
SectionP.CT: Test
Problem 1CT
icon
Related questions
Topic Video
Question

Relational algebra questions

### Sailors-Boats-Reserves Database Schema

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)**

Below is a detailed description of the data instances present in this database.

#### Sailors Table

| sid | sname   | rating | age  |
|-----|---------|--------|------|
| 22  | Dustin  | 7      | 45   |
| 29  | Brutus  | 1      | 33   |
| 31  | Lubber  | 8      | 55.5 |
| 32  | Andy    | 8      | 25.5 |
| 58  | Rusty   | 10     | 35   |
| 64  | Horatio | 7      | 35   |
| 71  | Zorba   | 10     | 16   |
| 74  | Horatio | 9      | 40   |
| 85  | Art     | 3      | 25.5 |
| 95  | Bob     | 3      | 63.5 |

#### Boats Table

| bid | bname      | color  |
|-----|------------|--------|
| 101 | Interlake  | blue   |
| 102 | Interlake  | red    |
| 103 | Clipper    | green  |
| 104 | Marine     | red    |

#### Reserves Table

| sid | bid | day        |
|-----|-----|------------|
| 22  | 101 | 2020-10-10 |
| 22  | 102 | 2020-10-10 |
| 22  | 103 | 2020-10-8  |
| 22  | 104 | 2020-10-7  |
| 31  | 102 | 2020-11-10 |
| 31  | 103 | 2020-11-6  |
| 31  | 104 | 2020-11-12 |
| 64  | 101 | 2020-9-5   |
| 64
Transcribed Image Text:### Sailors-Boats-Reserves Database Schema 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)** Below is a detailed description of the data instances present in this database. #### Sailors Table | sid | sname | rating | age | |-----|---------|--------|------| | 22 | Dustin | 7 | 45 | | 29 | Brutus | 1 | 33 | | 31 | Lubber | 8 | 55.5 | | 32 | Andy | 8 | 25.5 | | 58 | Rusty | 10 | 35 | | 64 | Horatio | 7 | 35 | | 71 | Zorba | 10 | 16 | | 74 | Horatio | 9 | 40 | | 85 | Art | 3 | 25.5 | | 95 | Bob | 3 | 63.5 | #### Boats Table | bid | bname | color | |-----|------------|--------| | 101 | Interlake | blue | | 102 | Interlake | red | | 103 | Clipper | green | | 104 | Marine | red | #### Reserves Table | sid | bid | day | |-----|-----|------------| | 22 | 101 | 2020-10-10 | | 22 | 102 | 2020-10-10 | | 22 | 103 | 2020-10-8 | | 22 | 104 | 2020-10-7 | | 31 | 102 | 2020-11-10 | | 31 | 103 | 2020-11-6 | | 31 | 104 | 2020-11-12 | | 64 | 101 | 2020-9-5 | | 64
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.
Recommended textbooks for you
Elementary Geometry For College Students, 7e
Elementary Geometry For College Students, 7e
Geometry
ISBN:
9781337614085
Author:
Alexander, Daniel C.; Koeberlein, Geralyn M.
Publisher:
Cengage,
Elementary Geometry for College Students
Elementary Geometry for College Students
Geometry
ISBN:
9781285195698
Author:
Daniel C. Alexander, Geralyn M. Koeberlein
Publisher:
Cengage Learning