Answer Happy

Note: Use SQL commands to create the
database, tables, records, and Queries.
Create the database SBRCOMMANDS and the following tables
Sailors, Boats, and Reserves which are reproduced
as follows:
Sailors(sid:
VARCHAR(2) PK, sname: VARCHAR(7), rating:
SMALLINT, age: DOUBLE
Boats(bid:
VARCHAR(3) PK, bname: VARCHAR (10), colour:
VARCHAR(6)
Reserves(sid: VARCHAR(2) FK,
bid: VARCHAR(3) FK, day: DATE)
Sailors
Reserves
Boats
sid
sname
rating
age
sid
bid
Day
bid
bname
colour
22
Dustin
7
45.0
22
101
10/10/98
29
Brutus
1
33.0
22
102
10/10/98
31
Lubber
8
55.5
22
103
10/8/98
32
Andy
8
25.5
22
104
10/7/98
58
Rusty
10
35.0
31
102
11/10/98
64
Horatio
7
35.0
31
103
11/6/98
71
Zorba
10
16.0
31
104
11/12/98
74
Horatio
9
35.0
64
101
9/5/98
85
Art
3
25.5
64
102
9/8/98
95
Bob
3
63.5
74
103
9/8/98
Enter the test data for the three tables as shown above, and
formulate following SQL Queries:
Question 1
Find the sailor ID, boat name, and colour of those boats
reserved on 9/8/98.
Question 2
Find the names of sailors who have reserved boat 103.
Question 3
Find the names of sailors who have reserved a red boat.
101
Interlake
blue
102
Interlake
red
103
Clipper
green
104
Marine
red