Data Modeling

The foundation of the data warehousing system is the data model. The first step in this stage is to build the Logical data model based on the user requirements and the next step would be to translate the Logical data model into a Physical data model.

Course Road map

An Introduction to DATA MODELING

E-R Data Model (Entities)

• ENTITY

• TYPES OF ENTITIES

• RELATIONSHIP

• TYPES OF RELATIONSHIP

• STEPS TO DESIGN TRANSACTIONAL DATABASE

• Normalization

1. 1^st normal form

2. 2nd normal form

3. 3rd normal form

4. Boyce- codd normal form (BCNF)

5. 4th normal form

6. 5^th normal form

De-normalization of database

Dimensional modeling

• Measures

• Fact

• Dimension

• Granularity

• Dimensional Data Model -sub-models:

o Star Schema Model

o Star Flake Schema Model

o Snow Flake Schema Model

o Extended Star Schema Model

o Galaxy Schema Model

• Surrogate key

• Level

• Hierarchy

• Types of facts

• Types of dimensions

• Designing a star schema dimensional model