Fact Table ER Diagrams: 920036

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.