SAILORS ( SID , SNAME , RATING , AGE ) 
BOATS ( BID , BNAME , COLOR )
RESERVES ( SID , BID , DATE )

Syntax

CREATE TABLE SAILORS ( 
  SID INTEGER , 
  SNAME VARCHAR(30) , 
  RATING INTEGER , 
  AGE INTEGER , 
  PRIMARY KEY(SID) );

CREATE TABLE BOATS (
  BID INTEGER ,
  BNAME VARCHAR(20) ,
  COLOR VARCHAR(20) ,
  PRIMARY KEY(BID) );

CREATE TABLE RESERVES (
  SID INTEGER , 
  BID INTEGER ,
  DAY DATE ,
  PRIMARY KEY(BID,SID) ,
  FOREIGN KEY(SID) REFERENCES SAILORS(SID) ,
  FOREIGN KEY(BID) REFERENCES BOATS(BID) );
  