helal

DROP TABLE  info_passengers CASCADE CONSTRAINT;
DROP TABLE information_flights CASCADE CONSTRAINT;
DROP TABLE info_tickt ;
CREATE TABLE info_passengers (
    name  VARCHAR2(15) NOT NULL ,
    age NUMBER(2),
    Nationality  VARCHAR2(10) NOT NULL,
    NOpassport NUMBER(20) NOT NULL ,
    CONSTRAINT const_NOpassport_pk PRIMARY KEY (NOpassport)
    ) ;


    CREATE  TABLE information_flights (
        Nfligh23t VARCHAR2(15) NOT NULL ,
        NumberFliight  VARCHAR2(15) NOT NULL,
        DateFlight DATE NOT NULL ,
        Travel_destination VARCHAR2(15) NOT NULL ,
        Flying_line VARCHAR2(15),
        CONSTRAINT const_NFlights_pk PRIMARY KEY (NumberFliight) );


        CREATE  TABLE info_tickt (
            NoTickt NUMBER(20) NOT NULL ,
            Gate VARCHAR2(9) NOT NULL ,
            seat NUMBER(3) NOT NULL ,
            prictickt NUMBER(4) NOT NULL ,
            NOpassport NUMBER(20) NOT NULL ,
            NumberFliight  VARCHAR2(15) NOT NULL  ,
             CONSTRAINT const_NumberFliight_fk foreign KEY ( NumberFliight ) references information_flights ( NumberFliight )  );