The Relational Model

• In a relational DBMS, the data items and the relationships among them are organized into tables

• • A table is a collection of records - rows
  • A record is a collection of related fields - cols
  • Each field of a database table contains a single data value
  • Each record in a table contains the same fields