Normal FormsA normal form is a rule about a table, usually involving dependencies. If the rule applies, then some kinds of anomalies are avoided. First normal form (1NF)Column types are simple values
Second normal form (2NF)Terminology: non-prime columnA non-prime column is a column that does not belong to any candidate key.2NFA relation is in 2NF if:
|