Netflix interview question

what is the second normal form in a database

Interview Answer

Anonymous

20 May 2013

A table that's in first NF is in second NF if no attribute outside of any candidate key is a functional dependency of any subset of a candidate key. Mnemonics: (non-key attributes depend on) `the key, the whole key, and nothing but the key -- so help me Codd`!-). The `whole key` is the second of these three normal forms.