---
# System prepended metadata

title: Normalisation

---

# 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)
