Relational Data Modeling

About

This section is about data Modeling applied to a relational structure (mostly table).

Relational databases normalize data, removing as much duplication as possible.

A relational database’s approach to data modeling is table-centric whereas the NoSql approach is query centric, in which specific queries define the structure.

See also the dimensional data modeling section that talks about data modeling for multidimensional data

Concepts

Steps

There are four steps in designing a database:

  • identify:
    • the entity sets
    • and the relationship sets
  • identify semantic information in the relationship sets (ie the mapping information - 1:n, 1:1, m:n))
  • define the value sets and attributes;
  • organize data into entity/relationship relations and decide primary keys.

Visualisation

Relational Data Modeling - Visualization

Task Runner