Question No. 3 [Marks 8, CLO 3] Create a star schema data warehouse for the following scenario: Salespersons serve customers with products from a number of stores. Customer has the following attributes: CustomerID, CustomerName, mobilenumber, and Gender. Product is defined by: ProductKey, ProductName, ProductActualCost, Product Sales Cost. Stores defined by: StoreID, StoreName, City, State, Country. Sales Person defined by: Sales PersonID, Sales PersonName, StoreID, telephone. Bold attributes are primary keys. Create Fact table to hold all your transactional entries with appropriate foreign key columns which refer to primary key column of your dimension tables. On top of that, this fact table should include: SalesInvoiceNumber, SalesDateKey, Sales TimeKey, Quantity, Sales TotalCost FactProductSales (SalesInvoiceNumber, SalesDateKey, SalesTimeKey, StoreID, CustomerID,ProductID, Sales PersonID, Quantity, ProductActualCost, Sales TotalCost)