Data Modeling

New Features in Erwin Release 2020 R1

Use 'Active' Model Templates to facilitate reusable modeling metadata and to implement/enforce enterprise standards Erwin Data Modeler is now certified…

4 years ago

Data Modeling Interview Question and Answer Videos

Video Tutorial 1: What is a Data Model and Data Modeler Responsibilities? What's in it: Data Model, High Level Data…

4 years ago

What is Entity Relationship Diagram (ER Diagram) or ERD?

Entity Relationship Diagram (also called as ER Diagram, ER Model, ERD) contains entities/attributes and relationships with those entities. ER Model…

6 years ago

Data Modeling Topics – Index

Data Modeling Data Modeling Overview Data Modeling Overview Data Modeling Development Cycle Steps to Create a Data Model Data Modeler…

6 years ago

Challenging Situations in Data Modeling

Challenges & Solutions in Data Modeling: Anyone can Learn Data Modeling Concepts by reading some books or going through online…

6 years ago

Fact Table

Fact Table | Star Schema: The centralized table in a star schema is called as FACT table. A fact table…

9 years ago

Designing Snowflake Schema

Snowflake Schema: A snowflake schema is a term that describes a star schema structure normalized through the use of outrigger…

9 years ago

Designing Star Schema

Star Schema: General Information In general, an organization is started to earn money by selling a product or by providing…

9 years ago

Slowly Changing Dimensions

What are Slowly Changing Dimensions? Dimensions that change over time are called Slowly Changing Dimensions. For instance, a product price changes…

9 years ago

Time Dimension

In a relational data model, for normalization purposes, year lookup, quarter lookup, month lookup, and week lookups are not merged…

9 years ago