QUE:

Below are few informational statements about Telly Sales Company Inc.

A) The department consists of employees who work exclusively for the sales department.

B) Each employee is given a quarterly SalesQuota to achieve at the beginning of every quarter.

C) The SalesQuota amount varies for each employee and it changes (either increases or decreases) every quarter.

D) Sales Department is looking to have an ability to run reports on an ad-hoc basis. The department need to have ability to select From and To date of the report. The report should be able to extract any older data since 2005 till date.

E) The report will typically consists of Employee details and SalesQuota given to the employee in a particular quarter.

F) The users of the report need to have ability to drill-down the report to Year and Quarter level. Drill-up is not required.

Employee details look as below:

Employee Id, Last Name, First Name, Gender, BirthDate, EmailAddress, Gender, SalesTerritory, Title

SalesQuota details look as below:

Employee Id, Quarter of the Year, SalesQuota

Based on the above-given information:

(i) Identify Fact and Dimension tables and check if its a Star Schema or Snow-flaked.

(ii) List the columns of the Fact and Dimension tables.

(iii) For each column identified in the fact and dimension table, write a statement on how you would map them using the source data or how would you populate the columns in Dimension and Fact table.