Create EMPLOYEESCONTACT Table

CREATE TABLE EMPLOYEESCONTACT(

CONTACTID NUMBER(4),

EMPLOYEEID NUMBER(7),

UNIT# NUMBER(7),

STREET# NUMBER(7) NOT NULL,

STREETNAME VARCHAR2(30) NOT NULL,

CITY VARCHAR2(30) NOT NULL,

PROVINCE VARCHAR2(30) NOT NULL,

COUNTRY VARCHAR2(30) NOT NULL,

POSTALCODE VARCHAR2(12),

PHONE# NUMBER(10) NOT NULL,

ALTERNATIVEPHONE# NUMBER(10),

EMAIL VARCHAR2(30));