Databases

How to store data?

Relational databases

This model organizes data into one or more tables (or "relations") of columns and rows, with a unique key identifying each row. Rows are also called records. Generally, each table/relation represents one "entity type" (such as customer or product). The rows represent instances of that type of entity (such as "Lee" or "chair") and the columns representing values attributed to that instance (such as address or price).

Tables

Columns

Rows

Lets model some data

Queries

general guidelines, not rules

3 parts: 

What am I doing?

What table am I doing it to?

Do I have any modifiers?

DatabaseDatabase

By Mark Dewey

DatabaseDatabase

  • 255