Normalization De-normalized database form Functional dependencies Candidate keys and primary key 1NF decomposition … 2NF decomposition … 3NF decomposition … BCNF if possible … Final result and discussion Normalized relational model Discussion