# Normalisation ## Agenda - Designing optimized structures for relational databases - Understanding the definition of „normalised“ relations. - Knowing the procedures for optimizing data design. - Assessing when to normalise (and when, possibly, not). - Knowing the several normal forms - Understanding the underlying problems and their solutions. - Applying the normalisation rules to relational database schemas. ## References - [Database normalization](https://en.wikipedia.org/wiki/Database_normalization) - William Kent, [A Simple Guide to Five Normal Forms in Relational Database Theory](http://www.bkent.net/Doc/simple5.htm), Communications of the ACM 26(2), Feb. 1983, 120-125. - [Griffith University Normalization Tool](https://www.ict.griffith.edu.au/normalization_tools/normalization/ind.php) - [Functional Dependencies and Normalization](https://app-ltphp-tst-ae.azurewebsites.net/normalization_tool/assets/Functional%20Dependencies%20and%20Normalization.pdf) - [Database Normalization – Normal Forms 1nf 2nf 3nf Table Examples](https://www.freecodecamp.org/news/database-normalization-1nf-2nf-3nf-table-examples/) ## The person behind it [Raymond F. Boyce - Wikipedia](https://en.wikipedia.org/wiki/Raymond_F._Boyce) ## Flashcards [Database Normalisation - AnkiWeb](https://ankiweb.net/shared/info/371855652)