БД аэропорта, где выбрать On Delete/Update Cascade/Restrict

-- tables
-- Table: Bilet
CREATE TABLE vios2476.Bilet (
    nomer_bileta CHAR(10)  NOT NULL,
    klass INT  NOT NULL,
    cena INT  NOT NULL,
    Klient_kod_klienta INT NOT NULL,
    Reis_Id_reisa INT  NOT NULL,
    CONSTRAINT Bilet_pk PRIMARY KEY (nomer_bileta)
);
 
 
-- Table: Klient
CREATE TABLE vios2476.Klient (
    kod_klienta INT  NOT NULL,
    vardas CHAR(30)  NOT NULL,
    familija CHAR(30)  NOT NULL,
    mesto_zhitelstva CHAR(50)  NOT NULL,
    CONSTRAINT Klient_pk PRIMARY KEY (kod_klienta)
);
 
 
-- Table: Samolet
CREATE TABLE vios2476.Samolet (
    bortovoj_nomer INT  NOT NULL,
    model VARCHAR(20)  NOT NULL,
    vremya_eksploatacii INT  NOT NULL,
    norma_bagaza INT  NOT NULL,
    kolichestvo_mest INT  NOT NULL,
    CONSTRAINT Samolet_pk PRIMARY KEY (bortovoj_nomer)
);
 
 
-- Table: Reis
CREATE TABLE vios2476.Reis (
    Id_reisa INT  NOT NULL,
    vremya_pribytija CHAR(10)  NOT NULL,
    data_reisa CHAR(10)  NOT NULL,
    Dannyje_reisa_id_dannyh_reisa INT  NOT NULL,
    Samolet_bortovoj_nomer INT  NOT NULL,
    CONSTRAINT Reis_pk PRIMARY KEY (Id_reisa)
);
 
 
-- Table: Dannyje_reisa
CREATE TABLE vios2476.Dannyje_reisa (
    id_dannyh_reisa INT  NOT NULL,
    mesto_vyleta CHAR(30)  NOT NULL,
    mesto_naznacenija CHAR(30)  NOT NULL,
    vremya_poleta CHAR(10)  NOT NULL,
    vremya_vyleta CHAR(10)  NOT NULL,
    CONSTRAINT Dannyje_reisa_pk PRIMARY KEY (id_dannyh_reisa)
);
 
 
ALTER TABLE Bilet ADD CONSTRAINT Bilet_Klient 
    FOREIGN KEY (Klient_kod_klienta)
    REFERENCES Klient (kod_klienta)
  --  NOT DEFERRABLE 
  --  INITIALLY IMMEDIATE 
;
 
-- Reference:  Bilet_Reis (table: Bilet)
 
 
ALTER TABLE Bilet ADD CONSTRAINT Bilet_Reis 
    FOREIGN KEY (Reis_Id_reisa)
    REFERENCES Reis (Id_reisa)
  --  NOT DEFERRABLE 
  --  INITIALLY IMMEDIATE 
;
 
-- Reference:  Reis_Samolet (table: Reis)
 
 
ALTER TABLE Reis ADD CONSTRAINT Reis_Samolet 
    FOREIGN KEY (Samolet_bortovoj_nomer)
    REFERENCES Samolet (bortovoj_nomer)
  --  NOT DEFERRABLE 
   -- INITIALLY IMMEDIATE 
;
 
-- Reference:  Reis_Dannyje_reisa (table: Reis)
 
 
ALTER TABLE Reis ADD CONSTRAINT Reis_Dannyje_reisa 
    FOREIGN KEY (Dannyje_reisa_id_dannyh_reisa)
    REFERENCES Dannyje_reisa (id_dannyh_reisa)
    
 --   NOT DEFERRABLE 
  --  INITIALLY IMMEDIATE 
;