Normalization in DBMS first normal form, second normal form and third normalization form
Normalization is a process that organize data and avoid data duplication and data redundancy. Normalization in DBMS first normal form, second normal form and third normal form avoid delete, update and insertion anomalies . Normalization in DBMS is a system that reduce data redundancy. Normalization in DBMS maintenance integrity constraint. Normalization in DBMS apply first normal for, second normal for and third normal for make new relations for avoid data redundancy.
With first normalization form we are try to remove repeating group of data. A repeating group has a primary key with a domain or set of domain, directly relating to the key.
First normal form: At first for fist normalization we see that how many columns and rows values are similar in this diagram, then this similar columns and rows values combine a new table and one primary key, and this relational table are also create another table by others columns and rows where have one primary key and one foreign key in this foreign key previous table that’s primary key.
Second normal form: The first normal form where have two table one is normalize and another is un-normalized. Now the un-normalized table we do the normalized by second normal form. This table have a composite primary key and they are make a new table of second normal form and where have others columns, rows and previous table where we use composite primary key one key is the primary key of this table and another is foreign key of normalized table because of establishing relationship.
Nesta página do site você pode assistir ao vídeo on-line Normalization in DBMS first normal form, second normal form and third normalization form duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Programming Contents 07 Dezembro 2016, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 1,775 vezes e gostou 12 espectadores. Boa visualização!
