Normalization beyond Third Normal Form

This page contains the description for my conference session “Normalization beyond Third Normal Form”, and links to the slide deck of this presentation.

Description

Target audience Intermediate and advanced DBAs and database developers.
Short description An explanation of the so-called “higher normal forms” that actually makes sense.
Duration The ideal length for this session is 60 – 75 minutes. It can be extended to 90 minutes by also including a short recapitulation of the “basic” normal forms.
Full abstract Do you believe the myths that “Third Normal Form is good enough”, or that “Higher Normal Forms are hard to understand”?

Do you believe the people who claim that these statements are myths?

Or do you prefer to form your own opinion?

If you take database design seriously, you cannot afford to miss this session. You will get a clear and easy to understand overview of all the higher Normal Forms: what they are, how to check if they are met, and what consequences their violations can have. This will arm you with the knowledge to reject the myths about higher Normal Forms. But, more important: it will make you a better designer!

Resources

Click here to download a ZIP file containing the slide deck of this presentation.

(Note: my presentations tend to evolve over time, so the version you find here may not be an exact match for the version you witnessed)

Recordings

Not able to attend a conference and still interested in this session? Just watch it on YouTube!

  • Option 1: Much longer version, recorded at home in multiple parts (all with manually created captions)
  • Option 2: Live recorded at PASS Virtual Summit 2020 (auto-generated captions)

 

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close