CREATE TABLE Sailors (sid Integer NOT NULL,
sname varchar(20),
rating integer,
age real,
PRIMARY KEY (sid));

CREATE TABLE Boats (bid Integer NOT NULL,
bname varchar(20),
color varchar(10),
PRIMARY KEY (bid));

CREATE TABLE Reserves (sid Integer NOT NULL,
bid Integer NOT NULL,
day date,
PRIMARY KEY (sid,bid),
FOREIGN KEY (sid) REFERENCES Sailors,
FOREIGN KEY (bid) REFERENCES Boats);

INSERT INTO Sailors VALUES (22,'Dustin',7,45.0);
INSERT INTO Sailors VALUES (31,'Lubber',8,55.5);
INSERT INTO Sailors VALUES (58,'Rusty',10,35.5);
INSERT INTO Sailors VALUES (28,'yuppy',9,35.0);
INSERT INTO Sailors VALUES (44,'guppy',5,35.5);
INSERT INTO Sailors VALUES (29,'Brutus',1,33.0);
INSERT INTO Sailors VALUES (32,'Andy',8,25.5);
INSERT INTO Sailors VALUES (64,'Horatio',7,35.0);
INSERT INTO Sailors VALUES (71,'Zorba',10,16.0);
INSERT INTO Sailors VALUES (74,'Horatio',9,35.5);
INSERT INTO Sailors VALUES (85,'Art',3,25.5);
INSERT INTO Sailors VALUES (95,'Bob',3,63.5);

INSERT INTO Boats VALUES (101,'Interlake','blue');
INSERT INTO Boats VALUES (102,'Interlake','red');
INSERT INTO Boats VALUES (103,'Clipper','green');
INSERT INTO Boats VALUES (104,'Marine','red');

INSERT INTO Reserves VALUES (22,101,'10/10/96');
INSERT INTO Reserves VALUES (22,102,'10/10/98');
INSERT INTO Reserves VALUES (22,103,'10/8/98');
INSERT INTO Reserves VALUES (22,104,'10/7/98');
INSERT INTO Reserves VALUES (31,102,'11/10/98');
INSERT INTO Reserves VALUES (31,103,'11/6/98');
INSERT INTO Reserves VALUES (31,104,'11/12/98');
INSERT INTO Reserves VALUES (64,101,'9/5/98');
INSERT INTO Reserves VALUES (64,102,'9/8/98');
INSERT INTO Reserves VALUES (74,103,'9/8/98');
INSERT INTO Reserves VALUES (58,103,'11/12/96');
