-----------------------------------------------------------------------
-----------------------------------------------------------------------
-----------------------------------------------------------------------
create table nationality ( nationality_id       Number(2)primary key,
                           nationality_name     Varchar2(25));
-----------------------------------------------------------------------
create table position    ( position_id          Number(2)primary key,
                           position_name        Varchar2(25));
-----------------------------------------------------------------------
create table department (  department_id        Number(2)primary key,
                           department_name      Varchar2(25));
-----------------------------------------------------------------------
CREATE TABLE  EMPLOYEE   ( 
              EMP_NO                            NUMBER(9)PRIMARY KEY,
              EMP_NAME                          NAME_TY,
              EMP_BIRTH                         BIRTH_TY,
              EMP_ID                            NUMBER(9),
              EMP_SEX                           NUMBER(1),
              EMP_MARITAL_STATUS                NUMBER(1),
              Emp_PHONE                             PHONE_TY,
              EMP_EMAIL                         VARCHAR2(25),
              EMP_ADDRESS                       ADDRESS_TY,
              NATIONALITY_ID                    NUMBER(2),
              POSITION_ID                       NUMBER(2),
              DEPARTMENT_ID                     NUMBER(2),
              CONSTRAINT EMP_NAT_FK FOREIGN KEY(NATIONALITY_ID)
              REFERENCES NATIONALITY(NATIONALITY_ID),
              CONSTRAINT EMP_POS_FK FOREIGN KEY(POSITION_ID)
              REFERENCES POSITION(POSITION_ID),
              CONSTRAINT EMP_DEP_FK FOREIGN KEY(DEPARTMENT_ID)
              REFERENCES DEPARTMENT(DEPARTMENT_ID));
-----------------------------------------------------------------------

CREATE TABLE  CUSTOMER   (  
              CUS_NO                            NUMBER(9)PRIMARY KEY,
              CUS_NAME                          NAME_TY,
              CUS_BIRTH                         BIRTH_TY,
              CUS_ID                            NUMBER(9),
              CUS_SEX                           NUMBER(1),
              CUS_PHONE                         PHONE_TY,
              CUS_EMAIL                         VARCHAR2(25),
              CUS_ADDRESS                       ADDRESS_TY);
-----------------------------------------------------------------------
CREATE TABLE  GOODS  ( 
              CUS_NO                            NUMBER(9),
              GOOD_SERIAL                       NUMBER(15) PRIMARY KEY,
              GOOD_NAME                         VARCHAR2(25),
              GOOD_PRICE                        NUMBER(8),
              GOOD_SALE_DATE                    DATE,
              CONSTRAINT GOOD_CUS_FK FOREIGN KEY(CUS_NO)
              REFERENCES CUSTOMER(CUS_NO));
-----------------------------------------------------------------------