Database: Design: Relational Database Terminology

A relational database requires that all data be represented in rectangular tables. This rigid structure will be natural for some problems and awkward for others, but after learning a few techniques for representing typical structures, it will feel quite natural. There are usually many ways to represent data in tables, some of which work better than others. The following explains some of the basic terminology, but not how to use it.

Tables

Rows

Columns

Some columns are keys

A column has a domain (datatype)