# cut and paste from this into your SQL window to create the necessary structures.

# warning: systems are highly sensitive to date format!
# if necessary, either change the date format or issue a command to 
# the dbms to read a different default format.

# The commands below erase the existing tables and create the example of section 5.2

###########################################

drop table sailors;

create table sailors (
   sid integer,
   sname varchar(255),
   rating	integer,
   age		float,
   primary key (sid)
);

insert into  sailors values (22,	'Dustin',	7,	45.0);
insert into  sailors values (29,	'Brutus',	1,	33.0);
insert into  sailors values (31,	'Lubber',	8,	55.51);
insert into  sailors values (32,	'Andy',	8,	25.5);
insert into  sailors values (58,	'Rusty',	10,	35.0);
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.0);
insert into  sailors values (85,	'Art',	3,	25.5);
insert into  sailors values (95,	'Bob',	3,	63.3);

#############################################

drop table boats;

create table boats (
    bid		integer,
    bname	varchar(255),
    color	varchar(255),
    primary key (bid)
)

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');


#############################################

drop table reserves;

create table reserves (
     sid	integer,
     bid	integer,
     day	date,
     primary key (sid, bid, day),
     foreign key (sid) references sailors,
     foreign key (bid) references boats
)
;


insert into reserves values(22,	101,	'10-10-1998');
insert into reserves values(22,	102,	'10-10-1998');
insert into reserves values(22,	103,	'08-10-1998');
insert into reserves values(22,	104,	'07-10-1998');
insert into reserves values(31,	102,	'10-11-1998');
insert into reserves values(31,	103,	'06-11-1998');
insert into reserves values(31,	104,	'12-11-1998');
insert into reserves values(64,	101,	'05-09-1998');
insert into reserves values(64,	102,	'08-09-1998');
insert into reserves values(74,	103,	'08-09-1998');