CREATE TABLE location
( location_id NUMBER(10) NOT NULL PRIMARY KEY,
  name VARCHAR2(30),
  region_id NUMBER(10)
)

CREATE SEQUENCE LOCATION_SEQ 
    START WITH 1
    INCREMENT BY 1
    MINVALUE 1
    NOMAXVALUE
    NOCYCLE
    NOCACHE
    ORDER


CREATE TABLE region (
   region_id NUMBER(10) NOT NULL PRIMARY KEY,
   name VARCHAR2(30), 
   division_id NUMBER(10)
)

CREATE SEQUENCE REGION_SEQ 
    START WITH 1
    INCREMENT BY 1
    MINVALUE 1
    NOMAXVALUE
    NOCYCLE
    NOCACHE
    ORDER



CREATE TABLE division (
   division_id NUMBER(10) NOT NULL PRIMARY KEY,
   name VARCHAR2(30)
)

CREATE SEQUENCE DIVISION_SEQ
    START WITH 1
    INCREMENT BY 1
    MINVALUE 1
    NOMAXVALUE
    NOCYCLE
    NOCACHE
    ORDER