(Relation|Table) - Tabular data
1 - About
Tables model either:
but not both.
Slightly outside of the tables in the data model, we have other kinds of tables:
- Staging tables bring in “dirty data” so we can scrub it and then insert it into base tables.
- Auxiliary tables hold static data for use in the system, acting as the relational replacement for computations.
In the SQL Iso, a table is a collection of zero or more rows where each row is a sequence of one or more column values.