Scenario: A large online companys marketing department needs information to examine sales, predict future directions, and determine how and what to advertise. Design a star schema to organize the sales information to meet the marketing department needs. Identify the dimensions first, and then identify the attributes of those dimensions. Provide examples from the answer I received earlier? Not understanding what has to be done. Believe I need tables (attribute and keys or dimensional table?) Unsure!

Dimensional Star Schema

Solution: You are already provided a star schema to organize the sales in the question itself, the star schema needs the below goals First need to identify business elements and models for the analysis of the business. Identify the facts those can be measured. Next identify the dimensions for the facts and then attributes of those dimensions. The fact tables will contain the numerical data associated with the events associated. Dimensions and their attributes The dimensions recognizes a higher domain The dimensions in the given star scheme are product, customer, Employee, Sales Facts, Sales and then demo. The attributes of the dimensions identified are the internal components resides in the dimension box. For example the customer dimension includes customer id, address, city, state, zipCode, etc. as the attributes. The dimensions are defined in terms of attributes and the dimensions required to identify the larger domains associated with the business. Since you are already provided a good star schema no need to design other