First Normal Form | Database Management System DBMS Tutorial | 1NF Example | 1NF, 2NF, 3NF, BCNF HD

29.10.2015
Database, Normalization, 1NF, 2NF, 3NF, BCNF, DBMS, Example, Hindi, Database, Normal Forms, Database Design 1NF (First Normal Form of Database Normalization) first normal form (1NF) with simple rules and examples.First normal form is the first step in database normalization. It has to do with making every column and value atomic. A relation is in first normal form if the domain of each attribute contains only atomic values, and the value of each attribute contains only a single value from that domain.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.

Похожие видео