Skip to content

Instantly share code, notes, and snippets.

View castletheperson's full-sized avatar

Castle Kerr castletheperson

View GitHub Profile

Keybase proof

I hereby claim:

  • I am castletheperson on github.
  • I am castletheperson (https://keybase.io/castletheperson) on keybase.
  • I have a public key whose fingerprint is 823E B5B3 FD98 E50E B1BD 1F3F D87A D380 319A 2D22

To claim this, I am signing this object:

@castletheperson
castletheperson / normalForms.md
Last active November 9, 2017 21:14 — forked from anonymous/normalForms.md
Database Normalization

1NF (definiton of a table)

  • has a primary key
  • no repeating columns
  • all values are scalar (atomic)
  • no dependent columns (computed columns)

2NF

  • in 1NF
  • no partial dependencies
  • i.e. if there is a composite key, no values rely on just a portion of the composite key