Free Shipping Across India | Pay Cash On Delivery | Call: 08030860796 (Mon - Sat)

search lense
Call Us :08030860796Let us call you

Normalization in dbms with examples ppt

 

Normalization is the process of designing a data model to efficiently store data in a database. The end result is that superfluous data is eliminating, and only data related to the quality is stored within the table.

For example, let's say we store City, State and ZipCode data for Customers in the same table as Other Customer data. With this approach, we keep repeating the City, State and ZipCode data for all Customers in the same area. Instead of storing the same data again and again, we could normalize the data and create a related table called City. The "City" table could then store City, State and ZipCode along with IDs that relate back to the Customer table, and we can eliminate those three columns from the Customer table and add the new ID column.  Normalization rules have been broken down into several forms. People often refer to the third normal form (3NF) when talking about database design.

In the design of a relational database management system (RDBMS), the process of organize data to minimize being without a job is called normalization. The goal of database normalization is to decay relations with anomaly in order to produce smaller, logical relations. Normalization usually involves dividing large, badly-formed tables into smaller, well-formed tables and important relationships between them. The objective is to cut off data so that additions, deletions, and modification of a field can be made in just one table and then propagated through the rest of the database via the defined relationships.

To download the Normalization in dbms with examples ppt Please click the following links.