CREATE TABLE Ship(
    name VARCHAR(30),
    yearLaunched SMALLINT,
    PRIMARY KEY (name)
    );

INSERT INTO Ship VALUES('USS Iowa', 1942);
INSERT INTO Ship VALUES('USS New Jersey', 1942);
INSERT INTO Ship VALUES('USS Missouri', 1944);
INSERT INTO Ship VALUES('USS Wisconsin', 1943);

INSERT INTO Ship VALUES('RMS Olympic', 1910);
INSERT INTO Ship VALUES('RMS Titanic', 1911);
INSERT INTO Ship VALUES('HMHS Britannic', 1914);

INSERT INTO Ship VALUES('Explorer of the Seas', 1999);
INSERT INTO Ship VALUES('Adventure of the Seas', 2001);

INSERT INTO Ship VALUES('USS Akron', 1931);
INSERT INTO Ship VALUES('USS Macon', 1933);

INSERT INTO Ship VALUES('Hindenburg', 1936);
INSERT INTO Ship VALUES('Graf Zeppelin II', 1938);

CREATE TABLE SisterOf(
    shipName VARCHAR(30),
    sisterName VARCHAR(30),
    PRIMARY KEY (shipName, sisterName)
    );

INSERT INTO SisterOf VALUES('USS Iowa', 'USS New Jersey');
INSERT INTO SisterOf VALUES('USS Iowa', 'USS Missouri');
INSERT INTO SisterOf VALUES('USS Iowa', 'USS Wisconsin');
INSERT INTO SisterOf VALUES('USS New Jersey', 'USS Iowa');
INSERT INTO SisterOf VALUES('USS New Jersey', 'USS Missouri');
INSERT INTO SisterOf VALUES('USS New Jersey', 'USS Wisconsin');
INSERT INTO SisterOf VALUES('USS Missouri', 'USS Iowa');
INSERT INTO SisterOf VALUES('USS Missouri','USS New Jersey');
INSERT INTO SisterOf VALUES('USS Missouri', 'USS Wisconsin');
INSERT INTO SisterOf VALUES('USS Wisconsin', 'USS Iowa');
INSERT INTO SisterOf VALUES('USS Wisconsin', 'USS New Jersey');
INSERT INTO SisterOf VALUES('USS Wisconsin', 'USS Missouri');

INSERT INTO SisterOf VALUES('RMS Olympic', 'RMS Titanic');
INSERT INTO SisterOf VALUES('RMS Olympic', 'HMHS Britannic');
INSERT INTO SisterOf VALUES('RMS Titanic', 'RMS Olympic');
INSERT INTO SisterOf VALUES('RMS Titanic', 'HMHS Britannic');
INSERT INTO SisterOf VALUES('HMHS Britannic', 'RMS Olympic');
INSERT INTO SisterOf VALUES('HMHS Britannic', 'RMS Titanic');

INSERT INTO SisterOf VALUES('Explorer of the Seas', 'Adventure of the Seas');
INSERT INTO SisterOf VALUES('Adventure of the Seas', 'Explorer of the Seas');

INSERT INTO SisterOf VALUES('USS Akron', 'USS Macon');
INSERT INTO SisterOf VALUES('USS Macon', 'USS Akron');

INSERT INTO SisterOf VALUES('Hindenburg', 'Graf Zeppelin II');
INSERT INTO SisterOf VALUES('Graf Zeppelin II', 'Hindenburg');
