You need to implement the Sales Commission model to support the planned reports and queries.
What should you do?
A . Create a date table that contains only one row for each date on which a sale is recorded.
B . Use the existing transaction date column in the sales table for date calculations.
C . Create a date table that contains a row for every date since data started being recorded.
D . Create a new calculated date column in the sales table for date calculations.
Answer: C