1. Declare the grain, foreign keys and measures in the fact table.

What would you consider the grain or finest level to be in each fact table cell? You may consult the course presentation to define your grain for this example. Also, define foreign keys that relate the fact table to your dimensions i.e., each foreign key in the fact table is a primary key in a dimension.

2. Think of other dimensions that can be added to this diagram, i.e., dimensions can provide what, who, where, how, when, why context to the business process.

What else can you add to the dimensions? You may ask where is this data coming from? The answer would be from Store Sales. Then, you may add a dimension named Store to your diagram.

3. Define attributes for each dimension.

You should list some attributes or column names for each dimension. Think of a simple tabular design for each dimension and the data to be stored for that dimension.

4. Propose a design pattern schema and provide a diagram of your proposed schema and explain your choice of schema.

Which schema do you choose to represent your data warehouse, e.g., Star, Snowflake? And explain why you chose it.

5. You may also propose a business process by your own e.g., a company digital wallet service and declare the fact table, dimension tables, etc. according to steps 1 to 4.

This part is OPTIONAL if you would like to choose another example of your own. So, either you answer step 1 to 4 according to the example provided or give your own example of business process e.g., e-wallet and answer step 1 to 4.