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.
Auf dieser Seite können Sie das Online-Video Normalization in DBMS first normal form, second normal form and third normalization form mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Programming Contents 07 Dezember 2016 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 1,775 Mal angesehen und es wurde von 12 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
