Relational Modeling

Table: stores records in rows and attributes in columns

Relation: Table that follows rules of a relational model

Table Rules

  1. Every column has a unique name

  2. No two rows are identical

  3. Each cell holds only one value (no lists)

  4. Each column has a set of allowed values

  5. Row and column order do not change the data