Normalization in Database DBMS 1NF 2NF 3NF with Example in hindi | Concepts, Tricks & ShortCut | 50 HD

Database, Normalization, 1NF, 2NF, 3NF, BCNF, DBMS, Example, Hindi, tutorial, Lecture, Database, Normal Forms, Explained with Examples, Database normalization (or normalisation) is the process of organizing the columns (attributes) and tables (relations) of a relational database to minimize data redundancy. Normalization - 1NF, 2NF, 3NF and 4NF,Primary Key, SQL - Structured Query Language, 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.