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.
En esta página del sitio puede ver el video en línea Normalization in DBMS first normal form, second normal form and third normalization form de Duración hora minuto segunda en buena calidad , que subió el usuario Programming Contents 07 diciembre 2016, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 1,775 veces y le gustó 12 a los espectadores. Disfruta viendo!
