Database Normalization - Explained with Examples

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 : http://w3schools.com/sql/default.asp Good Information on Joins : The examples are in DB2 They will be similar for other DBMS(s) http://www.ibm.com/developerworks/data/library/techarticle/purcell/0112purcell.html