You are required to build a data warehouse for a company that manufactures appliances and sells them to retailer customers. The company has collected required data from various operational databases and files. The relevant three dimensions and their attributes are described below. Period: period_key, month, quarter, year Customer customer_key, name, address, account_number, account_type, account_balance Product: product_key, category_name, category_on_hand, product_name, product_on_hand, product_unit_price Facts to be recorded in the Sales_facts table are 'sales' and 'profit', whose values depend on the combination of different dimension key values. Provide a star schema in text format for the entire data warehouse. Assume that you have already created, using SQL, the three dimension tables described in Question 29. Write an SQL statement to create the Sales_facts table. The keys of all tables are integer type, as well as sales and profit values. Clearly specify the primary key and foreign keys in the Sales_facts table. A customer may have several accounts, due to different delivery and payment terms. account_number uniquely determines account_type and account_balance. A product in the Product table can be classified to a certain product category, described by the category_name attribute. category_name uniquely determines category_on_hand. Answer the following questions: a. In what normal forms are the Customer and Product tables, respectively? Why? Assume that there is no multivalued attribute in the tables. b. If the Customer and Product tables are not in 3NF, decompose the tables into 3NF and provide the entire revised schema in text format. You are required to build a data warehouse for a company that manufactures appliances and sells them to retailer customers. The company has collected required data from various operational databases and files. The relevant three dimensions and their attributes are described below. Period: period_key, month, quarter, year Customer customer_key, name, address, account_number, account_type, account_balance Product: product_key, category_name, category_on_hand, product_name, product_on_hand, product_unit_price Facts to be recorded in the Sales_facts table are 'sales' and 'profit', whose values depend on the combination of different dimension key values. Provide a star schema in text format for the entire data warehouse. Assume that you have already created, using SQL, the three dimension tables described in Question 29. Write an SQL statement to create the Sales_facts table. The keys of all tables are integer type, as well as sales and profit values. Clearly specify the primary key and foreign keys in the Sales_facts table. A customer may have several accounts, due to different delivery and payment terms. account_number uniquely determines account_type and account_balance. A product in the Product table can be classified to a certain product category, described by the category_name attribute. category_name uniquely determines category_on_hand. Answer the following questions: a. In what normal forms are the Customer and Product tables, respectively? Why? Assume that there is no multivalued attribute in the tables. b. If the Customer and Product tables are not in 3NF, decompose the tables into 3NF and provide the entire revised schema in text format