Derivation Aggregation Summarization Horizontal Partitioning Vertical Partitioning Optimization Summary Physical Design and Implementation Implementing Relational Data Implementing Business Analytics Implementing OLAP Module Five: Summary and Conclusion Appendices Appendix A - Entity-Relationship Modeling Basics Relational Data Design Introduction to Entity/Relationship Modeling E/R Model Components Entities and Attributes Relationships Subtypes and Supertypes Reading E/R Models: E/R Models for Communication Appendix B Case Study – Appendix C Exercises – Exercise One Business Domains – Exercise Two Business Subjects – Exercise Three Fact Qualifier Matrix – Exercise Four Fact Qualifier Matrix Refinement – Exercise Five Logical Dimensional Model – Exercise Six Star Schema –
Derivation Aggregation Summarization Horizontal Partitioning Vertical Partitioning Optimization Summary Physical Design and Implementation Implementing Relational Data Implementing Business Analytics Implementing OLAP Module Five: Summary and Conclusion Appendices Appendix A - Entity-Relationship Modeling Basics Relational Data Design Introduction to Entity/Relationship Modeling E/R Model Components Entities and Attributes Relationships Subtypes and Supertypes Reading E/R Models: E/R Models for Communication Appendix B – Case Study Appendix C – Exercises Exercise One – Business Domains Exercise Two – Business Subjects Exercise Three – Fact Qualifier Matrix Exercise Four – Fact Qualifier Matrix Refinement Exercise Five – Logical Dimensional Model Exercise Six – Star Schema