create table COUNTRIES ( ID INTEGER IDENTITY, COUNTRY VARCHAR(200) not null, EU CHAR(1) default 'N' not null, constraint CTRY_UK unique (COUNTRY) ) create table STATES ( ID INTEGER IDENTITY, CTRY_ID INTEGER not null, STATE VARCHAR(200) not null, constraint STAT_UK unique (STATE), constraint STAT_CTRY_ID_FK foreign key (CTRY_ID) references COUNTRIES (ID) ) create table DISTRICTS ( ID INTEGER IDENTITY, STAT_ID INTEGER not null, DISTRICT VARCHAR(200), constraint DIST_UK unique (DISTRICT), constraint DIST_STAT_ID_FK foreign key (STAT_ID) references STATES (ID) )