Databases: Tables, Rows, and Columns

Jump to: navigation, search

Introduces some basic relational database terminology.


A database table is just that, a table with rows and columns. Different tables contain information about different types of things.


Each row in a database table represents one instance of the type of object described in that table. A row is also called a record.


The columns in a table are the set of facts that we keep track of about that type of object. A column is also called an attribute.


The Instructors table.

Instructors Table
Columns / Attributes
Rows /

Participant Affiliation Email
Scott Cain Ontario Institute for Cancer Research
Tim Carver Sanger Institute
Dave Clements NESCent
Stephen Ficklin Clemson University
Syed Haider EBI
Ian Holmes UC Berkeley
Carson Holt University of Utah carson.holt@utah.ed
Robin Houston Sanger Institute
Ed Lee Lawrence Berkeley National Lab
Sheldon McKay Cold Spring Harbor Laboratory
Joshua Orvis Institute for Genome Sciences
Mitch Skinner UC Berkeley
Giles Velarde Wellcome Trust Sanger Institute
Junjun Zhang Ontario Institute for Cancer Research