2. Use the CREATE with an embedded SELECT statement (and tables T_DATE, CUSTOMERS_COPY, ORDERS_COPY, and T_SALESMAN) to create and load the four dimensional tables D_ORDERS, D_CUSTOMERS, D_TIME and D_SALESMAN as they are described in Figure 7.1.

For each Dimension, define the PK constraint and name it as follows:

PK_D_ORDERS Primary Kay for D_ORDERS

PK_D_SALEMAN Primary Kay for D_SALEMAN

PK_D_TIME Primary Kay for D_TIME

PK_D_CUSTOMERS Primary Kay for D_CUSTOMERS