CREATE TABLE "customer" (
    "customer_id" NUMBER,
    "customer_pin" NUMBER,
    "customer_name" VARCHAR2,
    "customer_address" VARCHAR2,
    "customer_telephone" NUMBER,
    CONSTRAINT CUSTOMER_PK PRIMARY KEY ("customer_id")
CREATE SEQUENCE "CUSTOMER_SEQ"
/
CREATE TRIGGER "BI_CUSTOMER"
  before INSERT ON "CUSTOMER"
  FOR each ROW
BEGIN
  SELECT "CUSTOMER_SEQ".NEXTVAL INTO :NEW."customer_id" FROM dual;
END;
/

)
/
CREATE TABLE "employee" (
    "employee_id" NUMBER,
    "employee_name" VARCHAR2,
    "employee_telephone" VARCHAR2,
    "position" NUMBER,
    CONSTRAINT EMPLOYEE_PK PRIMARY KEY ("employee_id")
CREATE SEQUENCE "EMPLOYEE_SEQ"
/
CREATE TRIGGER "BI_EMPLOYEE"
  before INSERT ON "EMPLOYEE"
  FOR each ROW
BEGIN
  SELECT "EMPLOYEE_SEQ".NEXTVAL INTO :NEW."employee_id" FROM dual;
END;
/

)
/
CREATE TABLE "account" (
    "account_id" NUMBER,
    "account_number" NUMBER,
    "account_currency" VARCHAR2,
    "account_interest" DECIMAL,
    "account_amount" DECIMAL,
    "customer_id" NUMBER,
    CONSTRAINT ACCOUNT_PK PRIMARY KEY ("account_id")
CREATE SEQUENCE "ACCOUNT_SEQ"
/
CREATE TRIGGER "BI_ACCOUNT"
  before INSERT ON "ACCOUNT"
  FOR each ROW
BEGIN
  SELECT "ACCOUNT_SEQ".NEXTVAL INTO :NEW."account_id" FROM dual;
END;
/

)
/
CREATE TABLE "transaction" (
    "transaction_id" NUMBER,
    "customer_id" NUMBER,
    "type" NUMBER,
    "employee_id" NUMBER,
    "account_id" NUMBER,
    "transaction_amount" DECIMAL,
    CONSTRAINT TRANSACTION_PK PRIMARY KEY ("transaction_id")
CREATE SEQUENCE "TRANSACTION_SEQ"
/
CREATE TRIGGER "BI_TRANSACTION"
  before INSERT ON "TRANSACTION"
  FOR each ROW
BEGIN
  SELECT "TRANSACTION_SEQ".NEXTVAL INTO :NEW."transaction_id" FROM dual;
END;
/

)
/
CREATE TABLE "type" (
    "type_id" NUMBER,
    "type_name" VARCHAR2,
    CONSTRAINT TYPE_PK PRIMARY KEY ("type_id")
CREATE SEQUENCE "TYPE_SEQ"
/
CREATE TRIGGER "BI_TYPE"
  before INSERT ON "TYPE"
  FOR each ROW
BEGIN
  SELECT "TYPE_SEQ".NEXTVAL INTO :NEW."type_id" FROM dual;
END;
/

)
/
CREATE TABLE "position" (
    "position_id" NUMBER,
    "position_name" VARCHAR2,
    CONSTRAINT POSITION_PK PRIMARY KEY ("position_id")
CREATE SEQUENCE "POSITION_SEQ"
/
CREATE TRIGGER "BI_POSITION"
  before INSERT ON "POSITION"
  FOR each ROW
BEGIN
  SELECT "POSITION_SEQ".NEXTVAL INTO :NEW."position_id" FROM dual;
END;
/

)
/

ALTER TABLE "employee" ADD CONSTRAINT "employee_fk0" FOREIGN KEY ("position") REFERENCES position("position_id");

ALTER TABLE "account" ADD CONSTRAINT "account_fk0" FOREIGN KEY ("customer_id") REFERENCES customer("customer_id");

ALTER TABLE "transaction" ADD CONSTRAINT "transaction_fk0" FOREIGN KEY ("customer_id") REFERENCES customer("customer_id");
ALTER TABLE "transaction" ADD CONSTRAINT "transaction_fk1" FOREIGN KEY ("type") REFERENCES TYPE("type_id");
ALTER TABLE "transaction" ADD CONSTRAINT "transaction_fk2" FOREIGN KEY ("employee_id") REFERENCES employee("employee_id");
ALTER TABLE "transaction" ADD CONSTRAINT "transaction_fk3" FOREIGN KEY ("account_id") REFERENCES account("account_id");