How to Do Database Normalisation | Different Forms of Database Normalisation | UNF, 1NF, 2NF & 3NF

How to Do Database Normalisation | Different Forms of Database Normalisation | UNF, 1NF, 2NF & 3NFHow to Do Database Normalisation

Hope you enjoy this educational video.

Databases | Normalisation | Data Redundancy | Data Duplication | Normalised Form

Learn the Basics of Databases

#Databases
#Normalisation
#DrRezaRafiee
Created by Dr Reza Rafiee; @DrRezaRafiee @5MinuteAnalytics
All rights reserved.
Please share this video and subscribe the channel for more videos.

✓ SUBSCRIBE FOR MORE VIDEOS ✓

#################################
Music Track: Alan Walker - Fade [NCS Release]
Watch: https://www.youtube.com/watch?v=bM7SZ5SBzyY
NCS Spotify: http://spoti.fi/NCS

Music Track: Elektronomia - Limitless [NCS Release]
Watch: https://www.youtube.com/watch?v=cNcy3...
Free Download / Stream: http://ncs.io/Elimitless

Please leave a comment below.

0:00 Introduction
3:22 Normalisation Template
5:28 Un-normalised Form (UNF)
6:46 Student Registration Form
11:56 First Normal Form (INF)
13:49 Student Registration: UNF to INF
15:58 Atomic
17:33 Foreign Keys
18:53 Second Normal Form (2NF)
21:17 Student Registration: 1NF to 2NF
23:10 Third Normal Form (3NF)
25:49 Student Registration: 2NF to 3NF
26:25 Student Registration: UNF to 3NF
29:28 Final Schema
31:19 Practice #1: Normalise to 3NF

Видео How to Do Database Normalisation | Different Forms of Database Normalisation | UNF, 1NF, 2NF & 3NF канала 5-Minute Analytics