From GMOD
Introduces some basic relational database terminology.
Tables
A database table is just that, a table with rows and columns. Different tables contain information about different types of things.
Rows
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.
Columns
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.
Example
The Instructors table.
Instructors Table
|
| Columns / Attributes
|
Rows /
Records
|
| Participant
| Affiliation
| Email
|
| Scott Cain | Ontario Institute for Cancer Research | scott@scottcain.net
|
| Tim Carver | Sanger Institute | tjc@sanger.ac.uk
|
| Dave Clements | NESCent | clements@nescent.org
|
| Stephen Ficklin | Clemson University | ficklin@clemson.edu
|
| Syed Haider | EBI | syed@ebi.ac.uk
|
| Ian Holmes | UC Berkeley | ihh@berkeley.edu
|
| Carson Holt | University of Utah | carson.holt@utah.ed
|
| Robin Houston | Sanger Institute | rh11@sanger.ac.uk
|
| Ed Lee | Lawrence Berkeley National Lab | elee@berkeleybop.org
|
| Sheldon McKay | Cold Spring Harbor Laboratory | mckays@cshl.edu
|
| Joshua Orvis | Institute for Genome Sciences | jorvis@som.umaryland.edu
|
| Mitch Skinner | UC Berkeley | mitch_skinner@berkeley.edu
|
| Giles Velarde | Wellcome Trust Sanger Institute | gv1@sanger.ac.uk
|
| Junjun Zhang | Ontario Institute for Cancer Research | Junjun.Zhang@oicr.on.ca
|
|
