Relational Data Modeling

1 - 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

2 - Concepts

3 - 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.

4 - Visualisation

Data Science
Data Analysis
Data Science
Linear Algebra Mathematics

Powered by ComboStrap