Assume that your fact table is based on the ORDER_ITEMS_2K15 transaction (including its parent table ORDERS_2K15). Also assume that: DB BlockSize = 8K; PCTFREE = 2% for the fact Table & PCTFREE = 8% for the dimension tables; and = 5 (used for the INITRANS parameter) for all tables. a) Create a View PRODUCT_DIM_2K21_VW that corresponds to the Product dimension (i.e. PRODUCT_DIM_2K21) of a Star Schema and consists of the following fields: PRODUCT_ID, PRODUCT_NAME, LIST PRICE Level, CATEGORY_ID, CATEGORY_NAME where the values of LIST PRICE Level are based on the LIST_PRICE field as follows WHEN LIST_PRICES 1327 THEN_"Low'; WHEN 1327 2654 THEN_'High'. b. Given the view PRODUCT_DIM_2K21_VW, calculate the storage requirements of the PRODUCT_DIM_2K21 dimension table. o 0 C. Write a SQL DDL statement to CREATE the PRODUCT_DIM_2K21 dimension table. This statement should include an appropriate STORAGE clause. d. CREATE a view ORDERS_FACT_2K21_VW that corresponds to the fact table ORDERS_FACT_2K21. It should include the columns: CUSTOMER_PK, SALES_REP_ID, PRODUCT_ID, ORDER_DATE, Number of Orders (i.e. COUNT), Total Quantity (i.e. SUM(QUANTITY)), Total AMOUNT (i.e. SUM(QUANTITY* UNIT_PRICE)). Assume that your fact table is based on the ORDER_ITEMS_2K15 transaction (including its parent table ORDERS_2K15). Also assume that: DB BlockSize = 8K; PCTFREE = 2% for the fact Table & PCTFREE = 8% for the dimension tables; and = 5 (used for the INITRANS parameter) for all tables. a) Create a View PRODUCT_DIM_2K21_VW that corresponds to the Product dimension (i.e. PRODUCT_DIM_2K21) of a Star Schema and consists of the following fields: PRODUCT_ID, PRODUCT_NAME, LIST PRICE Level, CATEGORY_ID, CATEGORY_NAME where the values of LIST PRICE Level are based on the LIST_PRICE field as follows WHEN LIST_PRICES 1327 THEN_"Low'; WHEN 1327 2654 THEN_'High'. b. Given the view PRODUCT_DIM_2K21_VW, calculate the storage requirements of the PRODUCT_DIM_2K21 dimension table. o 0 C. Write a SQL DDL statement to CREATE the PRODUCT_DIM_2K21 dimension table. This statement should include an appropriate STORAGE clause. d. CREATE a view ORDERS_FACT_2K21_VW that corresponds to the fact table ORDERS_FACT_2K21. It should include the columns: CUSTOMER_PK, SALES_REP_ID, PRODUCT_ID, ORDER_DATE, Number of Orders (i.e. COUNT), Total Quantity (i.e. SUM(QUANTITY)), Total AMOUNT (i.e. SUM(QUANTITY* UNIT_PRICE))