Can someone help me with this Data Warehousing question? Thank you.

MATERIAL DI MATERIAL KEY: VARCHAR(20) MATERIAL_LABEL: VARCHAR(100) : ) MATERIAL VOM: VARCHAR(100) MATERIAL_KGPERUNIT: NUMBER MATERIAL_PHYS_STATE: VARCHAR(20) MATERIAL TOXIC : CHARI) MATERIAL_VOLATILE:CHAR(1) MATERIAL_FLAMMABLE CHAR(1) SUPPLY_FACT FACTORY_KEY: VARCHAR(20) MATERIAL_KEY: VARCHAR(20) MANUFACTURE_CAL_KEY: VARCHAR(50) SUPPLY_OTY NUMBER SUPPLY PKGS: NUMBER #SUPPLY_REJECTED_UNITS : NUMBER SUPPLY_COST: NUMBER(*. 2) FACTORY DM FACTORY KEY: VARCHAR(20) FACTORY LABEL: VARCHAR(100 FACTORY LOCATION VARCHAR(100) CALENDAR MANUFACTURE_DIM MANUFACTURE_CAL_KEY: VARCHAR(50 () MANUFACTURE SHIFT CODE: VARCHAR2(3) MANUFACTURE_DAY_DATETIMESTAMP MANIACI MANUFACTURE_DATE_SHIFT: VARCHAR2(20) MANUFACTURE YEARMONTH: VARCHARI20) MANUFACTURE_YEARMONTHDAY : VARCHAR2(20) MANUFACTURE_YEAR: VARCHAR(20) MANUFACTURE_YEARQUARTER : VARCHAR(20) MANUFACTURE MONTHOFYEAR VARCHAR(20) MANUFACTURE_QUARTERINYEAR: VARCHAR(20) MANUFACTURE FACT * PRODUCT_KEY: VARCHAR(100) : # MANUFACTURE CAL KEY: VARCHAR(50 FACTORY KEY: VARCHAR(20) #QTY PASSED: NUMBER #QTY FAILED: NUMBER # MATERIALS COST: NUMBER #FOREMAN_PERSON_KEY: VARCHAR(50) PERSON FOREMAN_DIM PERSON KEY VARCHARISO) PERSON SRC: VARCHAR(20) EMPLOYEE_ID_NAT: VARCHAR(50) PERSON LOCATION VARCHAR(100) PERSON_TITLE: VARCHAR(100) PRODUCT DIM & PRODUCT KEY: VARCHAR(100) * PRODUCT SKU: VARCHAR25) # PRODUCT_DESCRIPTION: VARCHAR(5000) # BRAND LABEL VARCHAR2(50) PERSON SALES_DIM PERSON_KEY: VARCHARISO) PERSON SRC: VARCHAR(50) EMPLOYEE ID NAT: VARCHAR(50) **OFFICE KEY: VARCHAR(50) ** TERRITORY_KEY: VARCHAR(50) REGION KEY: VARCHARL50 * OFFICE_LABEL: VARCHAR(200) TERRITORY LABEL: VARCHAR(200) REGION LABEL: VARCHAR(200) CALENDAR_SALES_DIM * SALES_DAY_KEY: VARCHAR(50) SALES DAY DATE TIMESTAMP SALES YEARMONTH : VARCHAR(20) SALES_YEAR: VARCHAR(20) SALES YEARQUARTER : VARCHARI20 *SALES MONTHOFYEAR: VARCHAR(20) #SALES QUARTERINYEAR: VARCHAR(20) SALES FACT #SALES PERSON KEY * CUST_PERSON_KEY PRODUCT KEY #SALES DAY KEY ITEM_QUANTITY ORDER CURRENCY ORDER_AMOUNT PERSON CUSTOMER_DM # PERSON KEY: VARCHAR(50) CUSTOMER LABEL VARCHAR(200) # CUSTOMER_SRC: VARCHAR(50) CUSTOMER_ID_NAT: VARCHARI50) # CUSTOMER STATEVARCHARIZ) # CUSTOMER_INDUSTRY_LABEL VARCHAR(200) SIC CODE: VARCHAR(20) A. What are the hierarchy columns in each dimension, in order from highest to lowest? B. What are the attribute columns in each dimension? C. Does any dimension have multiple hierarchies? D. What are the measures in each fact table? MATERIAL DI MATERIAL KEY: VARCHAR(20) MATERIAL_LABEL: VARCHAR(100) : ) MATERIAL VOM: VARCHAR(100) MATERIAL_KGPERUNIT: NUMBER MATERIAL_PHYS_STATE: VARCHAR(20) MATERIAL TOXIC : CHARI) MATERIAL_VOLATILE:CHAR(1) MATERIAL_FLAMMABLE CHAR(1) SUPPLY_FACT FACTORY_KEY: VARCHAR(20) MATERIAL_KEY: VARCHAR(20) MANUFACTURE_CAL_KEY: VARCHAR(50) SUPPLY_OTY NUMBER SUPPLY PKGS: NUMBER #SUPPLY_REJECTED_UNITS : NUMBER SUPPLY_COST: NUMBER(*. 2) FACTORY DM FACTORY KEY: VARCHAR(20) FACTORY LABEL: VARCHAR(100 FACTORY LOCATION VARCHAR(100) CALENDAR MANUFACTURE_DIM MANUFACTURE_CAL_KEY: VARCHAR(50 () MANUFACTURE SHIFT CODE: VARCHAR2(3) MANUFACTURE_DAY_DATETIMESTAMP MANIACI MANUFACTURE_DATE_SHIFT: VARCHAR2(20) MANUFACTURE YEARMONTH: VARCHARI20) MANUFACTURE_YEARMONTHDAY : VARCHAR2(20) MANUFACTURE_YEAR: VARCHAR(20) MANUFACTURE_YEARQUARTER : VARCHAR(20) MANUFACTURE MONTHOFYEAR VARCHAR(20) MANUFACTURE_QUARTERINYEAR: VARCHAR(20) MANUFACTURE FACT * PRODUCT_KEY: VARCHAR(100) : # MANUFACTURE CAL KEY: VARCHAR(50 FACTORY KEY: VARCHAR(20) #QTY PASSED: NUMBER #QTY FAILED: NUMBER # MATERIALS COST: NUMBER #FOREMAN_PERSON_KEY: VARCHAR(50) PERSON FOREMAN_DIM PERSON KEY VARCHARISO) PERSON SRC: VARCHAR(20) EMPLOYEE_ID_NAT: VARCHAR(50) PERSON LOCATION VARCHAR(100) PERSON_TITLE: VARCHAR(100) PRODUCT DIM & PRODUCT KEY: VARCHAR(100) * PRODUCT SKU: VARCHAR25) # PRODUCT_DESCRIPTION: VARCHAR(5000) # BRAND LABEL VARCHAR2(50) PERSON SALES_DIM PERSON_KEY: VARCHARISO) PERSON SRC: VARCHAR(50) EMPLOYEE ID NAT: VARCHAR(50) **OFFICE KEY: VARCHAR(50) ** TERRITORY_KEY: VARCHAR(50) REGION KEY: VARCHARL50 * OFFICE_LABEL: VARCHAR(200) TERRITORY LABEL: VARCHAR(200) REGION LABEL: VARCHAR(200) CALENDAR_SALES_DIM * SALES_DAY_KEY: VARCHAR(50) SALES DAY DATE TIMESTAMP SALES YEARMONTH : VARCHAR(20) SALES_YEAR: VARCHAR(20) SALES YEARQUARTER : VARCHARI20 *SALES MONTHOFYEAR: VARCHAR(20) #SALES QUARTERINYEAR: VARCHAR(20) SALES FACT #SALES PERSON KEY * CUST_PERSON_KEY PRODUCT KEY #SALES DAY KEY ITEM_QUANTITY ORDER CURRENCY ORDER_AMOUNT PERSON CUSTOMER_DM # PERSON KEY: VARCHAR(50) CUSTOMER LABEL VARCHAR(200) # CUSTOMER_SRC: VARCHAR(50) CUSTOMER_ID_NAT: VARCHARI50) # CUSTOMER STATEVARCHARIZ) # CUSTOMER_INDUSTRY_LABEL VARCHAR(200) SIC CODE: VARCHAR(20) A. What are the hierarchy columns in each dimension, in order from highest to lowest? B. What are the attribute columns in each dimension? C. Does any dimension have multiple hierarchies? D. What are the measures in each fact table