Normalization

Question 1

1NF violations

Answer 1

Using row order
Mixing data types in same column
No primary key
Repeating groups

Question 2

2NF rule

Answer 2

Each non-key attribute must depend on the entire primary key

Question 3

3NF forbids

Answer 3

Every non-key attribute in a table must depend on the key, the whole key, and nothing but the key.