1.     Fact Table ER Diagrams

·        Fact_Employee_Haedcount_Snapshot table: –

·        Fact_Employee_Title_Snapshot Table: –

·        Fact_Manager Table: –

·        Fact_Table: –

2.     Dimension Table ER Diagrams

·        Dim_EmpDate: –

·        Dim_Date: –

·        Dim_Department

·        Dim_Employee: –

·        Dim_Manager: –

·        Dim_Manager: –

·        Dim_Salary: –

·        Dim_Title: –

·        Dim_TitleDate: –

3.     Schema

4.     Bus Matrix

	Common Dimensions
Business Process	Dim_Emp	Dim_Department	Dim_Date	Dim_Title	Dim_Salary	Dim_Manger	Dim_TitleDate	Dim_EmpDate
track Hire date and Birth date of employee	X	X	X	X				X
track the start and end dates of each employee’s title(s)	X		X	X			X
track the start and end dates of each employee’s salary(s)	X		X		X
track the start and end dates of each employee’s manager(s)	X		X			X
Track the start and end dates of each employee’s department(s).	X	X

 

Bibliography: –

Inmon, W. (2011). Building the data warehouse. Indianapolis: Wiley.

Kimball, R., & Ross, M. (2013). The data warehouse toolkit. Hoboken, NJ: Wiley.

Kimball, R., Ross, M., Thornthwaite, W., Mundy, J., & Becker, B. (2011). The Data Warehouse Lifecycle Toolkit. Hoboken: John Wiley & Sons.