Relational Data Modeling

> (Data|State|Operand) Management and Processing > (Data Type|Data Structure) > (Relation|Table) - Tabular data > Relational Data Modeling

1 - About

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

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

2 - Concepts

Advertising

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