Skip to content

Instantly share code, notes, and snippets.

@githubutilities
Last active September 26, 2015 13:07
Show Gist options
  • Select an option

  • Save githubutilities/4f9500c99efddd6a33a5 to your computer and use it in GitHub Desktop.

Select an option

Save githubutilities/4f9500c99efddd6a33a5 to your computer and use it in GitHub Desktop.
Database Normal Form

Database Normal Form

data depends on the key [1NF], the whole key [2NF] and nothing but the key [3NF].

3NF vs BCNF

BCNF:

X->Y where Y can be prime or non-prime
Here,X must be a super key

3NF:

X->Y where Y is non-prime
then,
X must be a super key
else
X need not be super key
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment