DigitalAuts is a video gaming service that offers subscription-based access to online video games. You need to analyze sales performance a. Create a star schema model for the data that will allow you to compare revenue subscription counts by age grougs. Indicate which tables are the fact, the what, and the occurs tables Show the table relationship and their cardinalities. Provide at least three examples of columns for each table. Provide an example of a calculated column and an example of a measure. b. Define the algoritum for the calculated colamn in your example. What intormation modeling patiem is used for this column? c. Define the algorithm for the measure in your example. What information modeling pattern is used for this measure? Upload an Excel or zip tile that contains your algorithm and astar schema. (Zip is required if you choose to use Powerki or Tableau) Provide clear comments regandine the software used and the location within the Excel, PowerBl or Tableau file where your visualization is presented