Database management systems notes
Normal Forms
1NF through BCNF, derived rather than memorized, on one table taken apart step by step. Every section is a drawn page beside a clear written explanation, about 24 minutes in all.
- Chapter 14 of 34
- About 24 minutes
- 8 sections
Sign in with Google or GitHub and you land straight on this page. DSA comes with the all labs plan and every ChaiCode batch.
In this chapter
- First Normal Form: atomic values
- Second Normal Form: no partial dependencies
- Third Normal Form: no transitive dependencies
- Boyce-Codd Normal Form
- Lossless decomposition: not losing information
- Dependency preservation
- Fourth and Fifth Normal Forms
- The full decomposition, start to finish
Next chapters
Read the whole chapter
Sign in and the chapter opens with every drawn page, and all 35 database management systems chapters beside it.
DSA comes with the all labs plan and every ChaiCode batch.