Cruise Schema

create database cruise;
use cruise;

 create table E_CONTINENTS
(
    NAME varchar(20) not null,
    primary key (NAME)
);

insert into E_CONTINENTS
values ('EUROPE');
insert into E_CONTINENTS
values ('ASIA');
insert into E_CONTINENTS
values ('ANTARCTICA');
insert into E_CONTINENTS
values ('AFRICA');
insert into E_CONTINENTS
values ('AMERICA');
insert into E_CONTINENTS
values ('AUSTRALIA');

create table E_COUNTRIES
(
    NAME varchar(20) not null,
    primary key (NAME)
);

insert into E_COUNTRIES
values ('ITALY');
insert into E_COUNTRIES
values ('KROATIA');
insert into E_COUNTRIES
values ('TURKEY');
insert into E_COUNTRIES
values ('SICILY');
insert into E_COUNTRIES
values ('FRANCE');
insert into E_COUNTRIES
values ('SPAIN');
insert into E_COUNTRIES
values ('NORWAY');
insert into E_COUNTRIES
values ('JAPAN');
insert into E_COUNTRIES
values ('KOREA');
insert into E_COUNTRIES
values ('SOUTH_AFRICA');
insert into E_COUNTRIES
values ('UNITED_STATES');
insert into E_COUNTRIES
values ('BRAZIL');
insert into E_COUNTRIES
values ('MEXICO');
INSERT INTO E_COUNTRIES (NAME)
VALUES ('AUSTRIA');

create table HARBORS
(
    HARBOR_ID   int auto_increment,
    NAME        varchar(50)   not null unique,
    LOCATION    varchar(100)  not null,
    POSTAL_CODE varchar(8)    not null,
    STREET      varchar(100)  not null,
    COUNTRY     varchar(20)   not null,
    CONTINENT   varchar(20)   not null,
    primary key (HARBOR_ID),
    constraint FK_HARBORS_COUNTRY foreign key (COUNTRY)
        references E_COUNTRIES (NAME),
    constraint FK_HARBORS_CONTINENT foreign key (CONTINENT)
        references E_CONTINENTS (NAME)
);

insert into HARBORS (HARBOR_ID, NAME, LOCATION, POSTAL_CODE, STREET, COUNTRY, CONTINENT)
values (1, 'Ostia Harbor', 'Ostia', 'I-2315', 'la strada romana', 'ITALY', 'EUROPE');
insert into HARBORS (HARBOR_ID, NAME, LOCATION, POSTAL_CODE, STREET, COUNTRY, CONTINENT)
values (2, 'Rimini Harbor', 'Rimini', 'I-3154', 'la strada de fransecso 23', 'ITALY', 'EUROPE');
insert into HARBORS (HARBOR_ID, NAME, LOCATION, POSTAL_CODE, STREET, COUNTRY, CONTINENT)
values (3, 'Palermo Harbor', 'Palerma', 'S-2124', 'palace la corupti 31', 'SICILY', 'EUROPE');
insert into HARBORS (HARBOR_ID, NAME, LOCATION, POSTAL_CODE, STREET, COUNTRY, CONTINENT)
values (4, 'Venecia Harbor', 'Venecia', 'I-2123', 'Palzo Martino', 'ITALY', 'EUROPE');
insert into HARBORS (HARBOR_ID, NAME, LOCATION, POSTAL_CODE, STREET, COUNTRY, CONTINENT)
values (5, 'Marseille Harbor', 'Marseille', 'F-2153', 'la rui de gag', 'FRANCE', 'EUROPE');
insert into HARBORS (HARBOR_ID, NAME, LOCATION, POSTAL_CODE, STREET, COUNTRY, CONTINENT)
values (6, 'Montpellier Harbor', 'Montpellier', 'F-9812', 'la plaza de bonaparte', 'FRANCE', 'EUROPE');
insert into HARBORS (HARBOR_ID, NAME, LOCATION, POSTAL_CODE, STREET, COUNTRY, CONTINENT)
values (7, 'Barcelona Harbor', 'Barcelona', 'S-1125', 'playa de la barcelona', 'SPAIN', 'EUROPE');
insert into HARBORS (HARBOR_ID, NAME, LOCATION, POSTAL_CODE, STREET, COUNTRY, CONTINENT)
values (8, 'Tarragona Harbor', 'Tarragona', 'S-3154', 'circ roma de tarragona', 'SPAIN', 'EUROPE');
insert into HARBORS (HARBOR_ID, NAME, LOCATION, POSTAL_CODE, STREET, COUNTRY, CONTINENT)
values (9, 'Valencia Harbor', 'Valencia', 'S-3754', 'playa de las arenas', 'SPAIN', 'EUROPE');
insert into HARBORS (HARBOR_ID, NAME, LOCATION, POSTAL_CODE, STREET, COUNTRY, CONTINENT)
values (10, 'Osaka Harbor', 'Osaka', 'J-3219', 'maishima casmo', 'JAPAN', 'ASIA');
insert into HARBORS (HARBOR_ID, NAME, LOCATION, POSTAL_CODE, STREET, COUNTRY, CONTINENT)
values (11, 'Kobe Harbor', 'Kobe', 'J-0932', 'port island', 'JAPAN', 'ASIA');
insert into HARBORS (HARBOR_ID, NAME, LOCATION, POSTAL_CODE, STREET, COUNTRY, CONTINENT)
values (12, 'Hiroshima Harbor', 'Hiroshima', 'J-8301', 'minami ku', 'JAPAN', 'ASIA');
insert into HARBORS (HARBOR_ID, NAME, LOCATION, POSTAL_CODE, STREET, COUNTRY, CONTINENT)
values (13, 'Busan Harbor', 'Busan', 'K-3215', 'cheonghak', 'KOREA', 'ASIA');
insert into HARBORS (HARBOR_ID, NAME, LOCATION, POSTAL_CODE, STREET, COUNTRY, CONTINENT)
values (14, 'Gunsan Harbor', 'Gunsan', 'K-3312', 'byeonsanbando d2', 'KOREA', 'ASIA');
insert into HARBORS (HARBOR_ID, NAME, LOCATION, POSTAL_CODE, STREET, COUNTRY, CONTINENT)
values (15, 'Kapstadt Harbor', 'Kapstadt', 'SA-321', 'paarden eiland', 'SOUTH_AFRICA', 'AFRICA');
insert into HARBORS (HARBOR_ID, NAME, LOCATION, POSTAL_CODE, STREET, COUNTRY, CONTINENT)
values (16, 'Port Elisabeth Harbor', 'Port Elisabeth', 'SA-524', 'humewood extention', 'SOUTH_AFRICA', 'AFRICA');
insert into HARBORS (HARBOR_ID, NAME, LOCATION, POSTAL_CODE, STREET, COUNTRY, CONTINENT)
values (17, 'New York Harbor', 'New York', 'USA-23', 'long beach harbor', 'UNITED_STATES', 'AMERICA');
insert into HARBORS (HARBOR_ID, NAME, LOCATION, POSTAL_CODE, STREET, COUNTRY, CONTINENT)
values (18, 'Miami Harbor', 'Miami', 'USA-12', 'Miami Beach harbor', 'UNITED_STATES', 'AMERICA');
insert into HARBORS (HARBOR_ID, NAME, LOCATION, POSTAL_CODE, STREET, COUNTRY, CONTINENT)
values (19, 'Corpus Christi Harbor', 'Corpus Christi', 'USA-36', 'padre island', 'UNITED_STATES', 'AMERICA');
insert into HARBORS (HARBOR_ID, NAME, LOCATION, POSTAL_CODE, STREET, COUNTRY, CONTINENT)
values (20, 'Triest Harbor', 'Triest', 'I-3251', 'placa de concorde', 'ITALY', 'EUROPE');
insert into HARBORS (HARBOR_ID, NAME, LOCATION, POSTAL_CODE, STREET, COUNTRY, CONTINENT)
values (21, 'Pula Harbor', 'Pula', 'K-4285', 'Amfiteartu u puli', 'KROATIA', 'EUROPE');
insert into HARBORS (HARBOR_ID, NAME, LOCATION, POSTAL_CODE, STREET, COUNTRY, CONTINENT)
values (22, 'Split Harbor', 'Split', 'K-3763', 'Republic square', 'KROATIA', 'EUROPE');
INSERT INTO HARBORS (HARBOR_ID, NAME, LOCATION, POSTAL_CODE, STREET, COUNTRY, CONTINENT) VALUES (23, 'Krems Harbor', 'Krems a. d. Donau', 'K-3540', 'Hafenstrasse 13', 'AUSTRIA', 'EUROPE');


create table ROUTES_JT
(
    DEPARTURE_HARBOR_ID int not null,
    ARRIVAL_HARBOR_ID   int not null,
    NAME                varchar(100)  not null unique,
    DISTANCE            integer       not null,
    primary key (DEPARTURE_HARBOR_ID, ARRIVAL_HARBOR_ID),
    constraint fk_routes_ARRIVAL_HARBOR_ID foreign key (ARRIVAL_HARBOR_ID)
        references HARBORS (HARBOR_ID),
    constraint fk_routes_DEPARTURE_HARBOR_ID foreign key (DEPARTURE_HARBOR_ID)
        references HARBORS (HARBOR_ID)
);

insert into ROUTES_JT
values (2, 4, 'ITALY_ROUTE_1', 200);
insert into ROUTES_JT
values (4, 20, 'ITALY_ROUTE_2', 130);
insert into ROUTES_JT
values (20, 21, 'ITALY_ROUTE_3', 120);
insert into ROUTES_JT
values (21, 22, 'ITALY_ROUTE_4', 310);
insert into ROUTES_JT
values (4, 2, 'ITALY_ROUTE_REV_1', 200);
insert into ROUTES_JT
values (20, 4, 'ITALY_ROUTE_REV_2', 130);
insert into ROUTES_JT
values (21, 20, 'ITALY_ROUTE_REV_3', 120);
insert into ROUTES_JT
values (22, 21, 'ITALY_ROUTE_REV_4', 310);
insert into ROUTES_JT
values (1, 3, 'ITALY_ROUTE_5', 610);
insert into ROUTES_JT
values (3, 1, 'ITALY_ROUTE_REV_5', 610);
insert into ROUTES_JT
values (1, 5, 'FRANCE_ROUTE_1', 850);
insert into ROUTES_JT
values (5, 1, 'FRANCE_ROUTE_REV_1', 850);
insert into ROUTES_JT
values (5, 6, 'FRANCE_ROUTE_2', 120);
insert into ROUTES_JT
values (6, 5, 'FRANCE_ROUTE_REV_2', 120);
insert into ROUTES_JT
values (6, 7, 'SPAIN_ROUTE_1', 346);
insert into ROUTES_JT
values (7, 6, 'SPAIN_ROUTE_REV_1', 346);
insert into ROUTES_JT
values (7, 8, 'SPAIN_ROUTE_2', 100);
insert into ROUTES_JT
values (8, 7, 'SPAIN_ROUTE_REV_2', 100);
insert into ROUTES_JT
values (8, 9, 'SPAIN_ROUTE_3', 259);
insert into ROUTES_JT
values (9, 8, 'SPAIN_ROUTE_REV_3', 259);
insert into ROUTES_JT
values (10, 11, 'JAPAN_ROUTE_1', 33);
insert into ROUTES_JT
values (11, 10, 'JAPAN_ROUTE_REV_1', 33);
insert into ROUTES_JT
values (11, 12, 'JAPAN_ROUTE_2', 298);
insert into ROUTES_JT
values (12, 11, 'JAPAN_ROUTE_REV_2', 298);
insert into ROUTES_JT
values (12, 13, 'JAPAN_ROUTE_3', 405);
insert into ROUTES_JT
values (13, 12, 'JAPAN_ROUTE_REV_3', 405);
insert into ROUTES_JT
values (13, 14, 'KOREA_ROUTE_1', 525);
insert into ROUTES_JT
values (14, 13, 'KOREA_ROUTE_REV_1', 525);
insert into ROUTES_JT
values (15, 16, 'SOUTH_AFRICA_ROUTE_1', 1000);
insert into ROUTES_JT
values (16, 15, 'SOUTH_AFRICA_ROUTE_REV_1', 1000);
insert into ROUTES_JT
values (17, 18, 'US_ROUTE_1', 1278);
insert into ROUTES_JT
values (18, 17, 'US_ROUTE_REV_1', 1278);
insert into ROUTES_JT
values (18, 19, 'US_ROUTE_2', 1398);
insert into ROUTES_JT
values (19, 18, 'US_ROUTE_REV_2', 1398);
insert into ROUTES_JT
values (7, 17, 'ATLANTIC_ROUTE_1', 6162);
insert into ROUTES_JT
values (17, 7, 'ATLANTIC_ROUTE_REV_1', 6162);
insert into ROUTES_JT
values (9, 17, 'ATLANTIC_ROUTE_2', 6065);
insert into ROUTES_JT
values (17, 9, 'ATLANTIC_ROUTE_REV_2', 6065);
insert into ROUTES_JT
values (9, 15, 'ATLANTIC_ROUTE_3', 14500);
insert into ROUTES_JT
values (15, 9, 'ATLANTIC_ROUTE_REV_3', 14500);
insert into ROUTES_JT
values (16, 13, 'PACIFIC_ROUTE_1', 13791);
insert into ROUTES_JT
values (13, 16, 'PACIFIC_ROUTE_REV_1', 13791);
insert into ROUTES_JT
values (16, 12, 'PACIFIC_ROUTE_2', 14051);
insert into ROUTES_JT
values (12, 16, 'PACIFIC_ROUTE_REV_2', 14051);

CREATE TABLE E_SHIP_CLASSIFICATION
(
    TYPE VARCHAR(25) NOT NULL,
    PRIMARY KEY (TYPE)
);

INSERT INTO E_SHIP_CLASSIFICATION
VALUES ('AIRCRAFT_CARRIER');
INSERT INTO E_SHIP_CLASSIFICATION
VALUES ('SUBMARINE');
INSERT INTO E_SHIP_CLASSIFICATION
VALUES ('CRUISER');
INSERT INTO E_SHIP_CLASSIFICATION
VALUES ('DESTORYER');
INSERT INTO E_SHIP_CLASSIFICATION
VALUES ('SAILING_SHIP');
INSERT INTO E_SHIP_CLASSIFICATION
VALUES ('BATTLE_SHIP');
INSERT INTO E_SHIP_CLASSIFICATION
VALUES ('CRUISE_LINER');

create table SHIPS
(
    SHIP_ID             int auto_increment,
    NAME                varchar(50)   not null unique,
    SHIP_CLASSIFICATION varchar(25)   not null,
    PURCHASED_AT        date          not null,
    primary key (SHIP_ID),
    constraint fk_ship_ship_classifikation foreign key (SHIP_CLASSIFICATION)
        references E_SHIP_CLASSIFICATION (TYPE)
);

insert into SHIPS (SHIP_ID, NAME, SHIP_CLASSIFICATION, PURCHASED_AT)
values (1, 'WTF Pani', 'AIRCRAFT_CARRIER', str_to_date('10.09.1978', '%d.%m.%Y'));
insert into SHIPS (SHIP_ID, NAME, SHIP_CLASSIFICATION, PURCHASED_AT)
values (2, 'HMS Warspite', 'CRUISER', str_to_date('26.11.1913', '%d.%m.%Y'));
insert into SHIPS (SHIP_ID, NAME, SHIP_CLASSIFICATION, PURCHASED_AT)
values (3, 'Yamato', 'BATTLE_SHIP', str_to_date('08.08.1949', '%d.%m.%Y'));
insert into SHIPS (SHIP_ID, NAME, SHIP_CLASSIFICATION, PURCHASED_AT)
values (4, 'USS Hornet', 'AIRCRAFT_CARRIER', str_to_date('27.10.1942', '%d.%m.%Y'));
insert into SHIPS (SHIP_ID, NAME, SHIP_CLASSIFICATION, PURCHASED_AT)
values (5, 'Yellow Submairne', 'SUBMARINE', str_to_date('17.07.1968', '%d.%m.%Y'));
insert into SHIPS (SHIP_ID, NAME, SHIP_CLASSIFICATION, PURCHASED_AT)
values (6, 'AIDAprima', 'CRUISE_LINER', str_to_date('18.09.2017', '%d.%m.%Y'));


create table CRUISES
(
    CRUISE_ID         int auto_increment,
    LABEL             varchar(100)  not null,
    DATE_OF_DEPARTURE date          not null,
    DATE_OF_ARRIVAL   date,
    SHIP_ID           int not null,
    primary key (CRUISE_ID),
    constraint fk_CRUISES_SHIP_ID foreign key (SHIP_ID)
        references SHIPS (SHIP_ID)
);

insert into CRUISES (CRUISE_ID, LABEL, DATE_OF_DEPARTURE, DATE_OF_ARRIVAL, SHIP_ID)
values (1, 'Aida Adria', str_to_date('11.04.2020', '%d.%m.%Y'), str_to_date('14.04.2020', '%d.%m.%Y'), 6);
insert into CRUISES (CRUISE_ID, LABEL, DATE_OF_DEPARTURE, DATE_OF_ARRIVAL, SHIP_ID)
values (2, 'Japan picnic', str_to_date('10.09.2020', '%d.%m.%Y'), str_to_date('13.09.2020', '%d.%m.%Y'), 3);
insert into CRUISES (CRUISE_ID, LABEL, DATE_OF_DEPARTURE, DATE_OF_ARRIVAL, SHIP_ID)
values (3, 'Italy Cruise', str_to_date('11.09.2001', '%d.%m.%Y'), str_to_date('14.09.2001', '%d.%m.%Y'), 6);
insert into CRUISES (CRUISE_ID, LABEL, DATE_OF_DEPARTURE, DATE_OF_ARRIVAL, SHIP_ID)
values (4, 'Rivera Cruise', str_to_date('20.06.2008', '%d.%m.%Y'), str_to_date('27.06.2008', '%d.%m.%Y'), 6);
insert into CRUISES (CRUISE_ID, LABEL, DATE_OF_DEPARTURE, DATE_OF_ARRIVAL, SHIP_ID)
values (5, 'East Coast Cruise', str_to_date('01.01.2020', '%d.%m.%Y'), str_to_date('24.02.2020', '%d.%m.%Y'), 4);
insert into CRUISES (CRUISE_ID, LABEL, DATE_OF_DEPARTURE, DATE_OF_ARRIVAL, SHIP_ID)
values (7, 'Golden Cruise', str_to_date('01.01.2020', '%d.%m.%Y'), str_to_date('12.03.2020', '%d.%m.%Y'), 4);
INSERT INTO CRUISES (CRUISE_ID, LABEL, DATE_OF_DEPARTURE, DATE_OF_ARRIVAL, SHIP_ID) VALUES (8, 'Paulo Chiodo Cruise', str_to_date('01.12.2021', '%d.%m.%Y'), str_to_date('17.10.2022', '%d.%m.%Y'), 5);



create table CRUISE_HAS_ROUTES_JT
(
    CRUISE_ID           int not null,
    DEPARTURE_HARBOR_ID int not null,
    ARRIVAL_HARBOR_ID   int not null,
    DATE_OF_DEPARTURE   datetime          not null,
    DATE_OF_ARRIVAL     datetime,
    ROUTE_INDEX         integer       not null,
    primary key (CRUISE_ID, DEPARTURE_HARBOR_ID, ARRIVAL_HARBOR_ID),
    constraint FK_CHR_CRUISE_ID foreign key (CRUISE_ID)
        references CRUISES (CRUISE_ID),
    constraint FK_CHR_ROUTE_ID foreign key (DEPARTURE_HARBOR_ID, ARRIVAL_HARBOR_ID)
        references ROUTES_JT (DEPARTURE_HARBOR_ID, ARRIVAL_HARBOR_ID)
);

insert into CRUISE_HAS_ROUTES_JT (CRUISE_ID, DEPARTURE_HARBOR_ID, ARRIVAL_HARBOR_ID, DATE_OF_DEPARTURE, DATE_OF_ARRIVAL,
                                  ROUTE_INDEX)
values (1, 2, 4, str_to_date('11.04.2020 10:00:00', '%d.%m.%Y %H:%i:%s'),
        str_to_date('11.04.2020 15:10:00', '%d.%m.%Y %H:%i:%s'), 1);
insert into CRUISE_HAS_ROUTES_JT (CRUISE_ID, DEPARTURE_HARBOR_ID, ARRIVAL_HARBOR_ID, DATE_OF_DEPARTURE, DATE_OF_ARRIVAL,
                                  ROUTE_INDEX)
values (1, 4, 20, str_to_date('12.04.2020 10:00:00', '%d.%m.%Y %H:%i:%s'),
        str_to_date('12.04.2020 13:15:00', '%d.%m.%Y %H:%i:%s'), 2);
insert into CRUISE_HAS_ROUTES_JT (CRUISE_ID, DEPARTURE_HARBOR_ID, ARRIVAL_HARBOR_ID, DATE_OF_DEPARTURE, DATE_OF_ARRIVAL,
                                  ROUTE_INDEX)
values (1, 20, 21, str_to_date('13.04.2020 10:00:00', '%d.%m.%Y %H:%i:%s'),
        str_to_date('13.04.2020 13:15:00', '%d.%m.%Y %H:%i:%s'), 3);
insert into CRUISE_HAS_ROUTES_JT (CRUISE_ID, DEPARTURE_HARBOR_ID, ARRIVAL_HARBOR_ID, DATE_OF_DEPARTURE, DATE_OF_ARRIVAL,
                                  ROUTE_INDEX)
values (1, 21, 22, str_to_date('14.04.2020', '%d.%m.%Y %H:%i:%s'),
        str_to_date('14.04.2020 18:15:00', '%d.%m.%Y %H:%i:%s'), 4);
insert into CRUISE_HAS_ROUTES_JT (CRUISE_ID, DEPARTURE_HARBOR_ID, ARRIVAL_HARBOR_ID, DATE_OF_DEPARTURE, DATE_OF_ARRIVAL,
                                  ROUTE_INDEX)
values (2, 10, 11, str_to_date('10.09.2020 12:00:00', '%d.%m.%Y %H:%i:%s'),
        str_to_date('10.09.2020 14:00:00', '%d.%m.%Y %H:%i:%s'), 1);
insert into CRUISE_HAS_ROUTES_JT (CRUISE_ID, DEPARTURE_HARBOR_ID, ARRIVAL_HARBOR_ID, DATE_OF_DEPARTURE, DATE_OF_ARRIVAL,
                                  ROUTE_INDEX)
values (2, 11, 12, str_to_date('10.09.2020 20:00:00', '%d.%m.%Y %H:%i:%s'),
        str_to_date('11.09.2020 4:00:00', '%d.%m.%Y %H:%i:%s'), 2);
insert into CRUISE_HAS_ROUTES_JT (CRUISE_ID, DEPARTURE_HARBOR_ID, ARRIVAL_HARBOR_ID, DATE_OF_DEPARTURE, DATE_OF_ARRIVAL,
                                  ROUTE_INDEX)
values (2, 12, 13, str_to_date('11.09.2020 16:00:00', '%d.%m.%Y %H:%i:%s'),
        str_to_date('12.09.2020 6:00:00', '%d.%m.%Y %H:%i:%s'), 3);
insert into CRUISE_HAS_ROUTES_JT (CRUISE_ID, DEPARTURE_HARBOR_ID, ARRIVAL_HARBOR_ID, DATE_OF_DEPARTURE, DATE_OF_ARRIVAL,
                                  ROUTE_INDEX)
values (2, 13, 14, str_to_date('12.09.2020 18:00:00', '%d.%m.%Y %H:%i:%s'),
        str_to_date('13.09.2020 8:00:00', '%d.%m.%Y %H:%i:%s'), 4);
insert into CRUISE_HAS_ROUTES_JT (CRUISE_ID, DEPARTURE_HARBOR_ID, ARRIVAL_HARBOR_ID, DATE_OF_DEPARTURE, DATE_OF_ARRIVAL,
                                  ROUTE_INDEX)
values (3, 1, 3, str_to_date('11.09.2001 14:00:00', '%d.%m.%Y %H:%i:%s'),
        str_to_date('12.09.2001 14:00:00', '%d.%m.%Y %H:%i:%s'), 1);
insert into CRUISE_HAS_ROUTES_JT (CRUISE_ID, DEPARTURE_HARBOR_ID, ARRIVAL_HARBOR_ID, DATE_OF_DEPARTURE, DATE_OF_ARRIVAL,
                                  ROUTE_INDEX)
values (3, 3, 1, str_to_date('13.09.2001 20:00:00', '%d.%m.%Y %H:%i:%s'),
        str_to_date('14.09.2001 10:00:00', '%d.%m.%Y %H:%i:%s'), 2);
insert into CRUISE_HAS_ROUTES_JT (CRUISE_ID, DEPARTURE_HARBOR_ID, ARRIVAL_HARBOR_ID, DATE_OF_DEPARTURE, DATE_OF_ARRIVAL,
                                  ROUTE_INDEX)
values (4, 3, 1, str_to_date('20.06.2008 14:00:00', '%d.%m.%Y %H:%i:%s'),
        str_to_date('20.06.2008 20:00:00', '%d.%m.%Y %H:%i:%s'), 1);
insert into CRUISE_HAS_ROUTES_JT (CRUISE_ID, DEPARTURE_HARBOR_ID, ARRIVAL_HARBOR_ID, DATE_OF_DEPARTURE, DATE_OF_ARRIVAL,
                                  ROUTE_INDEX)
values (4, 1, 5, str_to_date('22.06.2008 10:00:00', '%d.%m.%Y %H:%i:%s'),
        str_to_date('23.06.2008 16:00:00', '%d.%m.%Y %H:%i:%s'), 2);
insert into CRUISE_HAS_ROUTES_JT (CRUISE_ID, DEPARTURE_HARBOR_ID, ARRIVAL_HARBOR_ID, DATE_OF_DEPARTURE, DATE_OF_ARRIVAL,
                                  ROUTE_INDEX)
values (4, 5, 6, str_to_date('24.06.2008 18:00:00', '%d.%m.%Y %H:%i:%s'),
        str_to_date('24.06.2008 22:00:00', '%d.%m.%Y %H:%i:%s'), 3);
insert into CRUISE_HAS_ROUTES_JT (CRUISE_ID, DEPARTURE_HARBOR_ID, ARRIVAL_HARBOR_ID, DATE_OF_DEPARTURE, DATE_OF_ARRIVAL,
                                  ROUTE_INDEX)
values (4, 6, 7, str_to_date('25.06.2008 14:00:00', '%d.%m.%Y %H:%i:%s'),
        str_to_date('25.06.2008 21:00:00', '%d.%m.%Y %H:%i:%s'), 4);
insert into CRUISE_HAS_ROUTES_JT (CRUISE_ID, DEPARTURE_HARBOR_ID, ARRIVAL_HARBOR_ID, DATE_OF_DEPARTURE, DATE_OF_ARRIVAL,
                                  ROUTE_INDEX)
values (4, 7, 8, str_to_date('26.06.2008 12:00:00', '%d.%m.%Y %H:%i:%s'),
        str_to_date('26.06.2008 14:00:00', '%d.%m.%Y %H:%i:%s'), 5);
insert into CRUISE_HAS_ROUTES_JT (CRUISE_ID, DEPARTURE_HARBOR_ID, ARRIVAL_HARBOR_ID, DATE_OF_DEPARTURE, DATE_OF_ARRIVAL,
                                  ROUTE_INDEX)
values (4, 8, 9, str_to_date('27.06.2008 14:00:00', '%d.%m.%Y %H:%i:%s'),
        str_to_date('27.06.2008 18:00:00', '%d.%m.%Y %H:%i:%s'), 6);
insert into CRUISE_HAS_ROUTES_JT (CRUISE_ID, DEPARTURE_HARBOR_ID, ARRIVAL_HARBOR_ID, DATE_OF_DEPARTURE, DATE_OF_ARRIVAL,
                                  ROUTE_INDEX)
values (5, 17, 18, str_to_date('01.01.2020 18:00:00', '%d.%m.%Y %H:%i:%s'),
        str_to_date('25.01.2020 10:00:00', '%d.%m.%Y %H:%i:%s'), 1);
insert into CRUISE_HAS_ROUTES_JT (CRUISE_ID, DEPARTURE_HARBOR_ID, ARRIVAL_HARBOR_ID, DATE_OF_DEPARTURE, DATE_OF_ARRIVAL,
                                  ROUTE_INDEX)
values (5, 18, 19, str_to_date('28.01.2020 10:00:00', '%d.%m.%Y %H:%i:%s'),
        str_to_date('24.02.2020 18:00:00', '%d.%m.%Y %H:%i:%s'), 2);

insert into CRUISE_HAS_ROUTES_JT (CRUISE_ID, DEPARTURE_HARBOR_ID, ARRIVAL_HARBOR_ID, DATE_OF_DEPARTURE, DATE_OF_ARRIVAL,
                                  ROUTE_INDEX)
values (7, 16, 13, str_to_date('01.01.2020 10:00:00', '%d.%m.%Y %H:%i:%s'),
        str_to_date('21.01.2020 18:00:00', '%d.%m.%Y %H:%i:%s'), 1);
insert into CRUISE_HAS_ROUTES_JT (CRUISE_ID, DEPARTURE_HARBOR_ID, ARRIVAL_HARBOR_ID, DATE_OF_DEPARTURE, DATE_OF_ARRIVAL,
                                  ROUTE_INDEX)
values (7, 13, 16, str_to_date('22.01.2020 10:00:00', '%d.%m.%Y %H:%i:%s'),
        str_to_date('22.03.2020 18:00:00', '%d.%m.%Y %H:%i:%s'), 2);


create table CABINS
(
    CABIN_NR    integer       not null,
    SHIP_ID     int not null,
    DESCRIPTION varchar(255)  not null,
    CABIN_SIZE  integer       not null,
    primary key (CABIN_NR, SHIP_ID),
    constraint fk_CABINS_SHIP_ID foreign key (SHIP_ID)
        references SHIPS (SHIP_ID)
);

insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (1, 1, 'CREW', 4);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (2, 1, 'CREW', 4);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (3, 1, 'CREW', 4);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (4, 1, 'CREW', 4);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (5, 1, 'CREW', 4);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (6, 1, 'CREW', 2);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (7, 1, 'CREW', 2);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (8, 1, 'CAPITAIN', 1);

insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (1, 2, 'CREW', 4);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (2, 2, 'CREW', 4);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (3, 2, 'CREW', 4);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (4, 2, 'CREW', 4);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (5, 2, 'CREW', 4);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (6, 2, 'CREW', 4);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (7, 2, 'CREW', 4);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (8, 2, 'CREW', 4);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (9, 2, 'CREW', 4);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (10, 2, 'CREW', 4);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (11, 2, 'CREW', 4);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (12, 2, 'CREW', 4);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (13, 2, 'CREW', 4);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (14, 2, 'CREW', 4);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (15, 2, 'CREW', 4);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (16, 2, 'CAPITAIN', 1);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (17, 2, 'MATE', 2);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (18, 2, 'MATE', 2);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (19, 2, 'MATE', 2);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (20, 2, 'MATE', 2);

insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (1, 3, 'CREW', 8);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (2, 3, 'CREW', 8);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (3, 3, 'CREW', 8);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (4, 3, 'CREW', 4);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (5, 3, 'CREW', 4);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (6, 3, 'CREW', 4);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (7, 3, 'CREW', 4);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (8, 3, 'CREW', 4);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (9, 3, 'CREW', 4);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (10, 3, 'CREW', 4);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (11, 3, 'CREW', 4);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (12, 3, 'CREW', 4);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (13, 3, 'GUNNERY', 5);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (14, 3, 'GUNNERY', 5);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (15, 3, 'GUNNERY', 4);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (16, 3, 'CAPITAIN', 1);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (17, 3, 'MATE', 1);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (18, 3, 'MATE', 1);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (19, 3, 'MATE', 1);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (20, 3, 'MATE', 2);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (21, 3, 'MATE', 2);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (22, 3, 'MATE', 2);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (23, 3, 'MATE', 2);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (24, 3, 'MATE', 2);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (25, 3, 'MATE', 2);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (26, 3, 'MATE', 2);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (27, 3, 'MATE', 2);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (28, 3, 'MATE', 3);

insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (1, 4, 'PASSENGER', 2);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (2, 4, 'PASSENGER', 4);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (3, 4, 'PASSENGER', 4);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (4, 4, 'PASSENGER', 4);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (5, 4, 'PASSENGER', 2);

insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (1, 5, 'GUEST', 1);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (2, 5, 'GUEST', 1);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (3, 5, 'GUEST', 3);

insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (1, 6, 'CAPITAIN', 1);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (2, 6, 'MATE', 1);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (3, 6, 'MATE', 2);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (4, 6, 'MATE', 2);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (5, 6, 'MATE', 2);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (6, 6, 'CREW', 4);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (7, 6, 'CREW', 4);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (8, 6, 'CREW', 4);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (9, 6, 'CREW', 4);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (10, 6, 'CREW', 4);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (11, 6, 'PASSENGER', 1);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (12, 6, 'PASSENGER', 1);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (13, 6, 'PASSENGER', 2);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (14, 6, 'PASSENGER', 2);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (15, 6, 'PASSENGER', 2);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (16, 6, 'PASSENGER', 2);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (17, 6, 'PASSENGER', 2);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (18, 6, 'PASSENGER', 3);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (19, 6, 'PASSENGER', 3);
insert into CABINS (CABIN_NR, SHIP_ID, DESCRIPTION, CABIN_SIZE)
values (20, 6, 'PASSENGER', 4);


CREATE TABLE E_EMPLOYEE_TYPE
(
    VALUE VARCHAR(10) NOT NULL,
    PRIMARY KEY (VALUE)
);

INSERT INTO E_EMPLOYEE_TYPE
VALUES ('SERVICE');
INSERT INTO E_EMPLOYEE_TYPE
VALUES ('OFFICER');
INSERT INTO E_EMPLOYEE_TYPE
VALUES ('ENGINEER');

create table EMPLOYEE_ST
(
    EMPLOYEE_ID   int auto_increment,
    FIRST_NAME    varchar(50)   not null,
    LAST_NAME     varchar(50)   not null,
    EMPLOYEE_TYPE varchar(10),
    primary key (EMPLOYEE_ID),
    constraint fk_EMPLOYEE_ST_type foreign key (EMPLOYEE_TYPE)
        references E_EMPLOYEE_TYPE (value)
);

insert into EMPLOYEE_ST (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMPLOYEE_TYPE)
values (1, 'Benjamin', 'Grabner', 'SERVICE');
insert into EMPLOYEE_ST (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMPLOYEE_TYPE)
values (2, 'Dominik', 'Hetzendorfer', 'ENGINEER');
insert into EMPLOYEE_ST (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMPLOYEE_TYPE)
values (3, 'Fabian Norber', 'Fandl', 'SERVICE');
insert into EMPLOYEE_ST (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMPLOYEE_TYPE)
values (4, 'Jan Anton', 'Daum', 'SERVICE');
insert into EMPLOYEE_ST (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMPLOYEE_TYPE)
values (5, 'Sebastian', 'Leutgeb', 'SERVICE');
insert into EMPLOYEE_ST (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMPLOYEE_TYPE)
values (6, 'Dominik', 'Poemmer', 'ENGINEER');
insert into EMPLOYEE_ST (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMPLOYEE_TYPE)
values (7, 'Dominik', 'Faltin', 'SERVICE');
insert into EMPLOYEE_ST (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMPLOYEE_TYPE)
values (8, 'Gabriel', 'Lugmayr', 'OFFICER');
insert into EMPLOYEE_ST (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMPLOYEE_TYPE)
values (9, 'Stefan', 'Wandl', 'ENGINEER');
insert into EMPLOYEE_ST (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMPLOYEE_TYPE)
values (10, 'Luka Tally', 'Boahm', 'SERVICE');
insert into EMPLOYEE_ST (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMPLOYEE_TYPE)
values (11, 'Thomas', 'Pfeisinger', 'SERVICE');
insert into EMPLOYEE_ST (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMPLOYEE_TYPE)
values (12, 'Tobias', 'Scherzer', 'SERVICE');
insert into EMPLOYEE_ST (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMPLOYEE_TYPE)
values (13, 'Mario', 'Rausch', 'ENGINEER');
insert into EMPLOYEE_ST (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMPLOYEE_TYPE)
values (14, 'Timo', 'Brand', 'SERVICE');
insert into EMPLOYEE_ST (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMPLOYEE_TYPE)
values (15, 'Martin', 'Kitzler', 'SERVICE');
insert into EMPLOYEE_ST (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMPLOYEE_TYPE)
values (16, 'Daniel', 'Gröblinger', 'ENGINEER');
insert into EMPLOYEE_ST (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMPLOYEE_TYPE)
values (17, 'Daniel', 'Holzner', 'SERVICE');
insert into EMPLOYEE_ST (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMPLOYEE_TYPE)
values (18, 'Lukas', 'Wansch', 'OFFICER');
insert into EMPLOYEE_ST (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMPLOYEE_TYPE)
values (19, 'Florian', 'Bruchner', 'SERVICE');
insert into EMPLOYEE_ST (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMPLOYEE_TYPE)
values (20, 'Tobias', 'Schrammel', 'SERVICE');
insert into EMPLOYEE_ST (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMPLOYEE_TYPE)
values (21, 'Niklas', 'Hofstetter', 'SERVICE');
insert into EMPLOYEE_ST (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMPLOYEE_TYPE)
values (22, 'Dominik', 'Neuwirth', 'SERVICE');
insert into EMPLOYEE_ST (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMPLOYEE_TYPE)
values (23, 'Florian', 'Poppinger', 'SERVICE');
insert into EMPLOYEE_ST (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMPLOYEE_TYPE)
values (24, 'Klaus', 'Huber', 'SERVICE');
insert into EMPLOYEE_ST (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMPLOYEE_TYPE)
values (25, 'Thomas', 'Huber', 'SERVICE');
insert into EMPLOYEE_ST (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMPLOYEE_TYPE)
values (26, 'David', 'Kurz', 'ENGINEER');
insert into EMPLOYEE_ST (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMPLOYEE_TYPE)
values (27, 'Nina', 'Kalch', 'ENGINEER');
insert into EMPLOYEE_ST (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMPLOYEE_TYPE)
values (28, 'Michael', 'Grötzel', 'ENGINEER');
insert into EMPLOYEE_ST (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMPLOYEE_TYPE)
values (29, 'Johannes', 'Kurz', 'ENGINEER');
insert into EMPLOYEE_ST (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMPLOYEE_TYPE)
values (30, 'Christoph', 'Fischer', 'ENGINEER');
insert into EMPLOYEE_ST (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMPLOYEE_TYPE)
values (31, 'Tobias', 'Kastl', 'OFFICER');
insert into EMPLOYEE_ST (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMPLOYEE_TYPE)
values (32, 'Mathias', 'Pichler', 'OFFICER');

CREATE TABLE E_EMPLOYEE_ROLE
(
    VALUE VARCHAR(20) NOT NULL,
    PRIMARY KEY (VALUE)
);

INSERT INTO E_EMPLOYEE_ROLE
VALUES ('CAPITAIN');
INSERT INTO E_EMPLOYEE_ROLE
VALUES ('1_MATE');
INSERT INTO E_EMPLOYEE_ROLE
VALUES ('2_MATE');
INSERT INTO E_EMPLOYEE_ROLE
VALUES ('3_MATE');
INSERT INTO E_EMPLOYEE_ROLE
VALUES ('STEERMAN');
INSERT INTO E_EMPLOYEE_ROLE
VALUES ('BOOTSMAN');
INSERT INTO E_EMPLOYEE_ROLE
VALUES ('COOK');
INSERT INTO E_EMPLOYEE_ROLE
VALUES ('WAITER');
INSERT INTO E_EMPLOYEE_ROLE
VALUES ('ENTERTAINMENT');
INSERT INTO E_EMPLOYEE_ROLE
VALUES ('SECURITY');
INSERT INTO E_EMPLOYEE_ROLE
VALUES ('ROOM_SERVICE');
INSERT INTO E_EMPLOYEE_ROLE
VALUES ('ELECTRICAIN');
INSERT INTO E_EMPLOYEE_ROLE
VALUES ('WOOD_WORK');
INSERT INTO E_EMPLOYEE_ROLE
VALUES ('CRAFTS_MAN');
INSERT INTO E_EMPLOYEE_ROLE
VALUES ('MACHINE_ENGINEER');

create table CRUISE_HAS_EMPLOYEES_JT
(
    CRUISE_ID     int not null,
    EMPLOYEE_ID   int not null,
    EMPLOYEE_ROLE varchar(20)   not null,
    primary key (CRUISE_ID, EMPLOYEE_ID),
    constraint fk_che_CRUISE_ID foreign key (CRUISE_ID)
        references CRUISES (CRUISE_ID),
    constraint fk_che_EMPLOYEE_ID FOREIGN KEY (EMPLOYEE_ID)
        references EMPLOYEE_ST (EMPLOYEE_ID),
    constraint fk_che_EMPLOYEE_ROLE foreign key (EMPLOYEE_ROLE)
        references E_EMPLOYEE_ROLE (value)
);

insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (1, 8, 'CAPITAIN');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (1, 18, '1_MATE');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (1, 24, 'COOK');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (1, 25, 'COOK');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (1, 23, 'COOK');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (1, 22, 'WAITER');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (1, 21, 'WAITER');

insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (1, 20, 'WAITER');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (1, 19, 'ROOM_SERVICE');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (1, 5, 'ROOM_SERVICE');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (1, 30, 'MACHINE_ENGINEER');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (1, 29, 'MACHINE_ENGINEER');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (1, 28, 'ELECTRICAIN');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (1, 27, 'ELECTRICAIN');

insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (2, 18, 'CAPITAIN');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (2, 31, '1_MATE');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (2, 19, 'COOK');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (2, 20, 'COOK');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (2, 21, 'WAITER');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (2, 22, 'ROOM_SERVICE');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (2, 2, 'ELECTRICAIN');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (2, 6, 'MACHINE_ENGINEER');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (2, 9, 'MACHINE_ENGINEER');


insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (3, 31, 'CAPITAIN');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (3, 18, '1_MATE');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (3, 3, 'COOK');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (3, 4, 'WAITER');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (3, 5, 'ROOM_SERVICE');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (3, 2, 'ELECTRICAIN');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (3, 6, 'MACHINE_ENGINEER');

insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (4, 8, 'CAPITAIN');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (4, 32, '3_MATE');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (4, 31, '2_MATE');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (4, 18, '1_MATE');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (4, 3, 'COOK');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (4, 4, 'COOK');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (4, 5, 'WAITER');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (4, 7, 'WAITER');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (4, 10, 'WAITER');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (4, 11, 'ROOM_SERVICE');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (4, 12, 'ROOM_SERVICE');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (4, 26, 'MACHINE_ENGINEER');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (4, 27, 'MACHINE_ENGINEER');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (4, 28, 'ELECTRICAIN');

insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (5, 8, 'CAPITAIN');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (5, 32, '3_MATE');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (5, 31, '2_MATE');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (5, 18, '1_MATE');

insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (7, 8, 'CAPITAIN');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (7, 32, '3_MATE');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (7, 31, '2_MATE');
insert into CRUISE_HAS_EMPLOYEES_JT (CRUISE_ID, EMPLOYEE_ID, EMPLOYEE_ROLE)
values (7, 18, '1_MATE');


create table TRAVELLERS
(
    TRAVELLER_ID int auto_increment,
    FIRST_NAME   varchar(45)   not null,
    LAST_NAME    varchar(45)   not null,
    primary key (TRAVELLER_ID)
);

insert into TRAVELLERS (TRAVELLER_ID, FIRST_NAME, LAST_NAME)
values (1, 'Jonas', 'Nagelmaier');
insert into TRAVELLERS (TRAVELLER_ID, FIRST_NAME, LAST_NAME)
values (2, 'Lukas', 'Wagner');
insert into TRAVELLERS (TRAVELLER_ID, FIRST_NAME, LAST_NAME)
values (3, 'Niklas', 'Taube');
insert into TRAVELLERS (TRAVELLER_ID, FIRST_NAME, LAST_NAME)
values (4, 'David', 'Kaufmann');
insert into TRAVELLERS (TRAVELLER_ID, FIRST_NAME, LAST_NAME)
values (5, 'Florian', 'Rauchberger');
insert into TRAVELLERS (TRAVELLER_ID, FIRST_NAME, LAST_NAME)
values (6, 'Florian', 'Pernikl');
insert into TRAVELLERS (TRAVELLER_ID, FIRST_NAME, LAST_NAME)
values (7, 'Julia', 'Schenk');
insert into TRAVELLERS (TRAVELLER_ID, FIRST_NAME, LAST_NAME)
values (8, 'Johanna', 'Bock');
insert into TRAVELLERS (TRAVELLER_ID, FIRST_NAME, LAST_NAME)
values (9, 'Simon', 'Hamanek');
insert into TRAVELLERS (TRAVELLER_ID, FIRST_NAME, LAST_NAME)
values (10, 'Sebastian', 'Miloczki');
insert into TRAVELLERS (TRAVELLER_ID, FIRST_NAME, LAST_NAME)
values (11, 'Jan', 'Specht');
insert into TRAVELLERS (TRAVELLER_ID, FIRST_NAME, LAST_NAME)
values (12, 'Christopher', 'Schwarz');
insert into TRAVELLERS (TRAVELLER_ID, FIRST_NAME, LAST_NAME)
values (13, 'Marc', 'Landsteiner');
insert into TRAVELLERS (TRAVELLER_ID, FIRST_NAME, LAST_NAME)
values (14, 'Gabriel', 'Zeller');
insert into TRAVELLERS (TRAVELLER_ID, FIRST_NAME, LAST_NAME)
values (15, 'Marcel', 'Genger');
insert into TRAVELLERS (TRAVELLER_ID, FIRST_NAME, LAST_NAME)
values (16, 'Marvin', 'Lochner');
insert into TRAVELLERS (TRAVELLER_ID, FIRST_NAME, LAST_NAME)
values (17, 'Dominik', 'Ferfecky');
insert into TRAVELLERS (TRAVELLER_ID, FIRST_NAME, LAST_NAME)
values (18, 'Tobias', 'Haidvogl');
insert into TRAVELLERS (TRAVELLER_ID, FIRST_NAME, LAST_NAME)
values (19, 'Thomas', 'Lueger');


create table BOOKINGS
(
    BOOKING_ID int auto_increment,
    BOOKED_AT  datetime          not null,
    primary key (BOOKING_ID)
);

insert into BOOKINGS (BOOKING_ID, BOOKED_AT)
values (1, str_to_date('01.04.2020 16:00:00', '%d.%m.%Y %H:%i:%s'));
insert into BOOKINGS (BOOKING_ID, BOOKED_AT)
values (2, str_to_date('25.03.2020 12:00:00', '%d.%m.%Y %H:%i:%s'));
insert into BOOKINGS (BOOKING_ID, BOOKED_AT)
values (3, str_to_date('25.03.2020 11:00:00', '%d.%m.%Y %H:%i:%s'));
insert into BOOKINGS (BOOKING_ID, BOOKED_AT)
values (4, str_to_date('25.08.2020 14:05:00', '%d.%m.%Y %H:%i:%s'));
insert into BOOKINGS (BOOKING_ID, BOOKED_AT)
values (5, str_to_date('26.08.2020 16:34:21', '%d.%m.%Y %H:%i:%s'));
insert into BOOKINGS (BOOKING_ID, BOOKED_AT)
values (6, str_to_date('10.09.2001 08:23:12', '%d.%m.%Y %H:%i:%s'));
insert into BOOKINGS (BOOKING_ID, BOOKED_AT)
values (7, str_to_date('10.08.2001 17:23:12', '%d.%m.%Y %H:%i:%s'));
insert into BOOKINGS (BOOKING_ID, BOOKED_AT)
values (8, str_to_date('21.07.2001 12:30:15', '%d.%m.%Y %H:%i:%s'));
insert into BOOKINGS (BOOKING_ID, BOOKED_AT)
values (9, str_to_date('15.06.2008 8:00:00', '%d.%m.%Y %H:%i:%s'));
insert into BOOKINGS (BOOKING_ID, BOOKED_AT)
values (10, str_to_date('14.06.2008 12:34:00', '%d.%m.%Y %H:%i:%s'));
insert into BOOKINGS (BOOKING_ID, BOOKED_AT)
values (11, str_to_date('10.12.2019 12:30:00', '%d.%m.%Y %H:%i:%s'));
insert into BOOKINGS (BOOKING_ID, BOOKED_AT)
values (12, str_to_date('09.09.2019 14:45:21', '%d.%m.%Y %H:%i:%s'));
insert into BOOKINGS (BOOKING_ID, BOOKED_AT)
values (13, str_to_date('09.09.2019 14:45:21', '%d.%m.%Y %H:%i:%s'));


create table CRUISE_HAS_BOOKINGS_JT
(
    CRUISE_ID    int not null,
    BOOKING_ID   int not null,
    TRAVELLER_ID int not null,
    CABIN_NR     integer       not null,
    SHIP_ID      int not null,
    PRICE        decimal(10,2)  not null,
    primary key (CRUISE_ID, BOOKING_ID, TRAVELLER_ID, CABIN_NR, SHIP_ID),
    constraint fk_chb_CRUISE_ID foreign key (CRUISE_ID)
        references CRUISES (CRUISE_ID),
    constraint fk_chb_BOOKING_ID foreign key (BOOKING_ID)
        references BOOKINGS (BOOKING_ID),
    constraint fk_chb_TRAVELLER_ID foreign key (TRAVELLER_ID)
        references TRAVELLERS (TRAVELLER_ID),
    constraint fk_chb_cabin_id foreign key (CABIN_NR, SHIP_ID)
        references CABINS (CABIN_NR, SHIP_ID)
);

insert into CRUISE_HAS_BOOKINGS_JT (CRUISE_ID, BOOKING_ID, TRAVELLER_ID, CABIN_NR, SHIP_ID, PRICE)
values (1,1,1,11,6,300.00);
insert into CRUISE_HAS_BOOKINGS_JT (CRUISE_ID, BOOKING_ID, TRAVELLER_ID, CABIN_NR, SHIP_ID, PRICE)
values (1,1,2,12,6,300.00);
insert into CRUISE_HAS_BOOKINGS_JT (CRUISE_ID, BOOKING_ID, TRAVELLER_ID, CABIN_NR, SHIP_ID, PRICE)
values (1,2,3,13,6,250.00);
insert into CRUISE_HAS_BOOKINGS_JT (CRUISE_ID, BOOKING_ID, TRAVELLER_ID, CABIN_NR, SHIP_ID, PRICE)
values (1,2,4,13,6,250.00);
insert into CRUISE_HAS_BOOKINGS_JT (CRUISE_ID, BOOKING_ID, TRAVELLER_ID, CABIN_NR, SHIP_ID, PRICE)
values (1,2,5,14,6,250.00);
insert into CRUISE_HAS_BOOKINGS_JT (CRUISE_ID, BOOKING_ID, TRAVELLER_ID, CABIN_NR, SHIP_ID, PRICE)
values (1,3,6,14,6,270.00);
insert into CRUISE_HAS_BOOKINGS_JT (CRUISE_ID, BOOKING_ID, TRAVELLER_ID, CABIN_NR, SHIP_ID, PRICE)
values (1,3,7,20,6,310.00);


insert into CRUISE_HAS_BOOKINGS_JT (CRUISE_ID, BOOKING_ID, TRAVELLER_ID, CABIN_NR, SHIP_ID, PRICE)
values (2,4,19,4,3,850.24);
insert into CRUISE_HAS_BOOKINGS_JT (CRUISE_ID, BOOKING_ID, TRAVELLER_ID, CABIN_NR, SHIP_ID, PRICE)
values (2,4,18,4,3,850.24);
insert into CRUISE_HAS_BOOKINGS_JT (CRUISE_ID, BOOKING_ID, TRAVELLER_ID, CABIN_NR, SHIP_ID, PRICE)
values (2,4,17,4,3,850.24);
insert into CRUISE_HAS_BOOKINGS_JT (CRUISE_ID, BOOKING_ID, TRAVELLER_ID, CABIN_NR, SHIP_ID, PRICE)
values (2,4,16,4,3,850.24);
insert into CRUISE_HAS_BOOKINGS_JT (CRUISE_ID, BOOKING_ID, TRAVELLER_ID, CABIN_NR, SHIP_ID, PRICE)
values (2,5,15,5,3,850.24);
insert into CRUISE_HAS_BOOKINGS_JT (CRUISE_ID, BOOKING_ID, TRAVELLER_ID, CABIN_NR, SHIP_ID, PRICE)
values (2,5,14,5,3,850.24);

insert into CRUISE_HAS_BOOKINGS_JT (CRUISE_ID, BOOKING_ID, TRAVELLER_ID, CABIN_NR, SHIP_ID, PRICE)
values (3,6,10,11,6,420.20);
insert into CRUISE_HAS_BOOKINGS_JT (CRUISE_ID, BOOKING_ID, TRAVELLER_ID, CABIN_NR, SHIP_ID, PRICE)
values (3,6,11,12,6,420.20);
insert into CRUISE_HAS_BOOKINGS_JT (CRUISE_ID, BOOKING_ID, TRAVELLER_ID, CABIN_NR, SHIP_ID, PRICE)
values (3,7,12,13,6,380.20);
insert into CRUISE_HAS_BOOKINGS_JT (CRUISE_ID, BOOKING_ID, TRAVELLER_ID, CABIN_NR, SHIP_ID, PRICE)
values (3,7,13,13,6,380.20);
insert into CRUISE_HAS_BOOKINGS_JT (CRUISE_ID, BOOKING_ID, TRAVELLER_ID, CABIN_NR, SHIP_ID, PRICE)
values (3,8,14,14,6,380.20);


insert into CRUISE_HAS_BOOKINGS_JT (CRUISE_ID, BOOKING_ID, TRAVELLER_ID, CABIN_NR, SHIP_ID, PRICE)
values (4,9,4,20,6,450.00);
insert into CRUISE_HAS_BOOKINGS_JT (CRUISE_ID, BOOKING_ID, TRAVELLER_ID, CABIN_NR, SHIP_ID, PRICE)
values (4,9,5,20,6,450.00);
insert into CRUISE_HAS_BOOKINGS_JT (CRUISE_ID, BOOKING_ID, TRAVELLER_ID, CABIN_NR, SHIP_ID, PRICE)
values (4,9,6,20,6,450.00);
insert into CRUISE_HAS_BOOKINGS_JT (CRUISE_ID, BOOKING_ID, TRAVELLER_ID, CABIN_NR, SHIP_ID, PRICE)
values (4,9,7,20,6,450.00);
insert into CRUISE_HAS_BOOKINGS_JT (CRUISE_ID, BOOKING_ID, TRAVELLER_ID, CABIN_NR, SHIP_ID, PRICE)
values (4,10,8,19,6,470.50);
insert into CRUISE_HAS_BOOKINGS_JT (CRUISE_ID, BOOKING_ID, TRAVELLER_ID, CABIN_NR, SHIP_ID, PRICE)
values (4,10,9,19,6,470.50);
insert into CRUISE_HAS_BOOKINGS_JT (CRUISE_ID, BOOKING_ID, TRAVELLER_ID, CABIN_NR, SHIP_ID, PRICE)
values (4,10,10,19,6,470.50);
insert into CRUISE_HAS_BOOKINGS_JT (CRUISE_ID, BOOKING_ID, TRAVELLER_ID, CABIN_NR, SHIP_ID, PRICE)
values (4,10,11,15,6,520.90);
insert into CRUISE_HAS_BOOKINGS_JT (CRUISE_ID, BOOKING_ID, TRAVELLER_ID, CABIN_NR, SHIP_ID, PRICE)
values (4,10,12,15,6,520.90);


insert into CRUISE_HAS_BOOKINGS_JT (CRUISE_ID, BOOKING_ID, TRAVELLER_ID, CABIN_NR, SHIP_ID, PRICE)
values (5,11,1,2,4,560.20);
insert into CRUISE_HAS_BOOKINGS_JT (CRUISE_ID, BOOKING_ID, TRAVELLER_ID, CABIN_NR, SHIP_ID, PRICE)
values (5,11,2,2,4,560.20);
insert into CRUISE_HAS_BOOKINGS_JT (CRUISE_ID, BOOKING_ID, TRAVELLER_ID, CABIN_NR, SHIP_ID, PRICE)
values (5,11,3,2,4,560.20);
insert into CRUISE_HAS_BOOKINGS_JT (CRUISE_ID, BOOKING_ID, TRAVELLER_ID, CABIN_NR, SHIP_ID, PRICE)
values (5,11,4,2,4,560.20);
insert into CRUISE_HAS_BOOKINGS_JT (CRUISE_ID, BOOKING_ID, TRAVELLER_ID, CABIN_NR, SHIP_ID, PRICE)
values (5,11,5,1,4,560.20);
insert into CRUISE_HAS_BOOKINGS_JT (CRUISE_ID, BOOKING_ID, TRAVELLER_ID, CABIN_NR, SHIP_ID, PRICE)
values (5,12,6,1,4,760.20);
insert into CRUISE_HAS_BOOKINGS_JT (CRUISE_ID, BOOKING_ID, TRAVELLER_ID, CABIN_NR, SHIP_ID, PRICE)
values (5,12,7,5,4,760.20);

insert into CRUISE_HAS_BOOKINGS_JT (CRUISE_ID, BOOKING_ID, TRAVELLER_ID, CABIN_NR, SHIP_ID, PRICE)
values (2,13,1 ,1,4,300.00);
insert into CRUISE_HAS_BOOKINGS_JT (CRUISE_ID, BOOKING_ID, TRAVELLER_ID, CABIN_NR, SHIP_ID, PRICE)
values (3,13,1 ,1,4,300.00);
insert into CRUISE_HAS_BOOKINGS_JT (CRUISE_ID, BOOKING_ID, TRAVELLER_ID, CABIN_NR, SHIP_ID, PRICE)
values (4,13,1 ,1,4,300.00);
insert into CRUISE_HAS_BOOKINGS_JT (CRUISE_ID, BOOKING_ID, TRAVELLER_ID, CABIN_NR, SHIP_ID, PRICE)
values (5,13,1 ,1,4,300.00);
insert into CRUISE_HAS_BOOKINGS_JT (CRUISE_ID, BOOKING_ID, TRAVELLER_ID, CABIN_NR, SHIP_ID, PRICE)
values (7,13,1 ,1,4,300.00);

commit;

-- drop table cruise_has_Routes_jt;
-- drop table routes_jt;
-- drop table harbors;
-- drop table e_countries;
-- drop table e_continents;
-- drop table cruise_has_employees_jt;
-- drop table EMPLOYEE_ST;
-- drop table e_employee_type;
-- drop table e_employee_role;
-- drop table cruise_has_bookings_jt;
-- drop table travellers;
-- drop table bookings;
-- drop table cabins;
-- drop table cruises;
-- drop table ships;
-- drop table e_ship_classification;