CREATE TABLE COUNTRY(
  COUNTRY_ID INT NOT NULL AUTO_INCREMENT,
  COUNTRY_DESCRIPTION VARCHAR(40) NOT NULL,
  COUNTRY_TENANT VARCHAR(4) NOT NULL,
  PRIMARY KEY ( COUNTRY_ID )
);

CREATE TABLE STATE(
  STATE_ID INT NOT NULL AUTO_INCREMENT,
  STATE_NAME VARCHAR(40) NOT NULL,
  COUNTRY_ID INT NOT NULL,
  STATE_TENANT VARCHAR(4) NOT NULL,
  PRIMARY KEY(STATE_ID),
  FOREIGN KEY(COUNTRY_ID)
    REFERENCES COUNTRY(COUNTRY_ID)
);

CREATE TABLE LOCALITY(
  LOCALITY_ID INT NOT NULL AUTO_INCREMENT,
  LOCALITY_NAME VARCHAR(40) NOT NULL,
  STATE_ID INT NOT NULL,
  PRIMARY KEY(LOCALITY_ID),
  FOREIGN KEY(STATE_ID)
    REFERENCES STATE(STATE_ID)
);

CREATE TABLE POPULATION(
  POPULATION_ID INT NOT NULL AUTO_INCREMENT,
  POPULATION_NAME VARCHAR(40) NOT NULL,
  POPULATION_GENDER VARCHAR(4) NOT NULL,
  LOCALITY_ID INT NOT NULL,
  PRIMARY KEY(POPULATION_ID),
  FOREIGN KEY(LOCALITY_ID)
    REFERENCES LOCALITY(LOCALITY_ID)
);