Create TRANSACTIONS Table

CREATE TABLE TRANSACTIONS (

TRANSACTIONID NUMBER(24),

CUSTOMERID NUMBER(12) NOT NULL,

EMPLOYEEID NUMBER(7) NOT NULL,

“DATE” DATE NOT NULL,

EXCHANGERATE NUMBER(6,2) NOT NULL,

MONEYAMOUNT NUMBER(10,2) NOT NULL,

CURRENCYTYPE CHAR(3) NOT NULL,

PAYMENTMETHOD CHAR NOT NULL,

DELIVERYMETHOD CHAR NOT NULL);