Create CUSTOMERSCONTACT Table

CREATE TABLE CUSTOMERSCONTACT(

CONTACTID NUMBER(14),

CUSTOMERID NUMBER(12),

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));