CREATE TABLE boats (
    bid integer NOT NULL,
    bname character varying(20),
    color character varying(10)
);


CREATE TABLE reserves (
    sid integer NOT NULL,
    bid integer NOT NULL,
    day date
);


CREATE TABLE sailors (
    sid integer NOT NULL,
    sname character varying(20),
    rating integer,
    age real
);


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


INSERT INTO reserves VALUES (22, 102, '1998-10-10');
INSERT INTO reserves VALUES (22, 103, '1998-10-08');
INSERT INTO reserves VALUES (22, 104, '1998-10-07');
INSERT INTO reserves VALUES (31, 102, '1998-11-10');
INSERT INTO reserves VALUES (31, 103, '1998-11-06');
INSERT INTO reserves VALUES (31, 104, '1998-11-12');
INSERT INTO reserves VALUES (64, 101, '1998-09-05');
INSERT INTO reserves VALUES (64, 102, '1998-09-08');
INSERT INTO reserves VALUES (74, 103, '1998-09-08');
INSERT INTO reserves VALUES (22, 101, '1998-10-10');
INSERT INTO reserves VALUES (55, 6, '1999-10-10');




INSERT INTO sailors VALUES (64, 'Horatio', 7, 35);
INSERT INTO sailors VALUES (74, 'Horatio', 9, 35.5);
INSERT INTO sailors VALUES (22, 'Dustin', 1, 45);
INSERT INTO sailors VALUES (31, 'Lubber', 8, NULL);
INSERT INTO sailors VALUES (58, 'Rusty', 10, 35.5);
INSERT INTO sailors VALUES (29, 'Brutus', 1, 33);
INSERT INTO sailors VALUES (71, 'Zorba', 10, 16);
INSERT INTO sailors VALUES (95, 'Bob', 3, 63.5);
INSERT INTO sailors VALUES (32, 'Andy', 8, NULL);
INSERT INTO sailors VALUES (85, 'Art', 3, 25.5);