Education

• BS, Forestry, University of Washington

• MS, SAFS, University of Washington

Appointments

• UW Alaska Salmon Program (2004-2007)

• Founder, Sound Data Management (2008-present)

• Co-founder, Sharper Informatics Solutions (2020-present)

“A relational database is a digital database based on the relational model of data, as proposed by E. F. Codd in 1970.”

Relational databases are created and manipulated using Structured Query Language (SQL)

Relational database software (RDBMS) allow users to create relational databases using SQL

Some well know RDBMS include

• PostgreSQL
  
• MySQL
  
• Oracle
  
• Microsoft SQL Server

Relational databases store data in tables

• Each database table is a named collection of rows

• Each row of a given table has the same set of named columns

• Each column is of a specific data type

• Table, field/column, record

• Primary and foreign keys

• Joins

• Atomic values

• Null values

• Query and result set

• View

• Data are stored in tables

• Columns in a table are fixed fields

• Fields have unique data types (eg, INTEGER, TEXT)

• Rows are unique records

• Columns have a fixed order in each table, but SQL does not guarantee the order of the rows within a table

• Tables are grouped into databases

• A collection of databases managed by a single PostgreSQL server instance constitutes a database cluster

“[every] non-key [attribute] must provide a fact about the key, the whole key, and nothing but the key, so help me Codd.”