Database Normalization: Sixth Normal Form

preview_player
Показать описание
In this video, we explain what Sixth Normal Form (6NF) is and why it slots in as the third most-important normal form. We look at two separate use cases in which 6NF can make sense and I provide some guidance on when 5NF is good enough versus when 6NF is better.

LINKS AND INFO
  1. Kevin Feasel
Рекомендации по теме
Database Normalization: Sixth 0:10:52

Database Normalization: Sixth Normal Form

Learn Database Normalization 0:28:34

Learn Database Normalization - 1NF, 2NF, 3NF, 4NF, 5NF

Anchor Modelling: Sixth 1:06:37

Anchor Modelling: Sixth Normal Form Databases! - Stephanie Locke

1st, 2nd and 0:11:42

1st, 2nd and 3rd Normal Form (Database Normalisation)

DBMS - Domain 0:02:55

DBMS - Domain Key Normal Form (DKNF) and Sixth Normal Form (6NF)

Database Normalization: Fourth 0:11:06

Database Normalization: Fourth Normal Form

Database design made 0:24:39

Database design made easy, part 9: Sixth Normal Form

Database Normalization for 0:02:09

Database Normalization for Beginners - 1NF, 2NF, 3NF, BCNF, 4NF, 5NF, EKNF, ETNF & DKNF

Relational Database Design/6: 0:34:31

Relational Database Design/6: Normal Forms

Normalization in SQL 0:13:48

Normalization in SQL | Database Normalization Forms - 1NF, 2NF, 3NF, BCNF | Edureka Rewind - 6

Database Normalization: What 0:15:41

Database Normalization: What and Why

database normalization 0:20:04

database normalization

Perfectly Normal: an 1:42:01

Perfectly Normal: an Advanced Primer on Normalization

Database Design 36 0:06:51

Database Design 36 - 1NF (First Normal Form of Database Normalization)

Introduction to Database 0:05:09

Introduction to Database Normalization

Normalization Practice Exercise 0:04:53

Normalization Practice Exercise | Third Normal Form| Denormalization

Database design made 0:14:51

Database design made easy, part 10: Optimal Normal Form

Database Normalization - 0:16:39

Database Normalization - Multivalued Dependencies and Fourth Normal Form | Database Tutorial 6m

Normal Forms 0:07:50

Normal Forms

Normalization - 1NF, 0:19:02

Normalization - 1NF, 2NF, 3NF and 4NF

Lec 17b-Needs of 0:11:28

Lec 17b-Needs of Normalization, Normal Forms, Steps in Normalization

CSIS 1550: Database 0:42:17

CSIS 1550: Database Normalization

How to Normalize 0:09:02

How to Normalize a Database Table

Database Normalization Theory 0:25:52

Database Normalization Theory 1NF to 6NF simplified

Комментарии
Автор

This was a really nice series! Somebody asked me a question about normalization, I'm going to send them over here.

I am a fan of NULLs, but I do realize they are dangerous. The truth is that in SQL you cannot escape them, because of outer joins and other language constructs. Think of them like heart surgery; if you need it. It's very very handy, however, if you don't need it, NULL should not be your first choice.

jcelko
Автор

nice job showing a 6nf example on a data model with 1nf violation...

youtubeenjoyer