Views for BCNF and connected reference chains | Boyes-Codd Normal Form | Reference chains | Views as a solution | Proper handling of nullable data | Handling of duplicate records

Terminology | Motivation | Database normalisation | For data cleaning | Not for database design | To third normal form | Individual steps | Finding functional dependencies | Normalisation | Adding foreign key references | Decomposing the original relation | Rejoining a database back into a data frame | Tuning detection and normalisation | Avoidable attributes

Initial decomposition | Simplifying the search result | Fixing the data | Simplifying further with search filters | How not to remove spurious structure | Alternative approach: hierarchical limits

Missing values | Decomposing to remove missing values | Structure conditional on value presence

Meaningful duplicate rows / row order | Value-based constraints | Semantic types | Table merges don't fix issues with merge.data.frame | Synthesis doesn't minimise relation key count | Normal forms are't all there is to database design