emp table: primary key EMP_CODE, foreign key STORE_CODE, secondary key (EMP_FNAME, EMP_LNAME, EMP_DOB).

store table: primary key STORE_CODE, foreign keys REGION_CODE and EMP_CODE, secondary key (STORE_NAME, STORE_YTD_SALES).

For region table: primary key REGION_CODE, foreign key NONE, secondary key REGION_DE_SCRIPT

what the relationship between? (1:1, 1:M, M:N, or none)

employ-store:

employ-region:

store-region: