253,542 views 784 on YTPak
1,051 108

Published on 26 Sep 2011 | over 5 years ago

Watch the full video with the examples and I GUARANTEE you will understand normalization and the 3 normal forms
Please SHARE, LIKE & COMMENT

Introduction to Normalization and the three normal forms with examples of violations and how to correct them!!

Please use the video for understanding normalization as there may be inaccuracies. Please Comment/email computingbasics001@gmail.com if you know of any INACCURATE/WRONG Information.

ACRONYMS / DEFINITIONS (
PK - Primary Key
SQL - Structured Query Language
ID - identifier
NORMALIZATION - Organizing , Splitting Information to remove redundancy AND
increase Consistency
JOIN - Combining Information from different tables
REDUNDANCY - Unnecessary data , Duplication
CONSISTENCY - Irrespective of how you access data you get same result
TRANSITIVITY - Derivation from multiple pieces of information)

In normalization you split information in tables
To get the split information you need to use JOINS

Good Site to Learn and practice SQL : w3schools.com/sql/default.asp

Good Information on Joins : The examples are in DB2 They will be similar for other DBMS(s)
www.ibm.com/developerworks/data/library/techarticle/purcell/0112purcell.html

Loading related videos...