Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Explain the Importance of Data Normalization.

Answer Posted / hr@tgksolutions.com

The practice of structuring data to reduce redundancy and enhance data integrity is known as data normalization. It entails creating associations between the smaller tables in a database. The significance of normalization is that it

minimizes the duplication of data.
guarantees the consistency of the data.

simplifies the structure, which facilitates updating and maintenance.
removes unneeded data to improve query performance.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to debug stored procedures?

900


What is a 3nf table?

829


What is rdbms and also explain its components?

1004


How big is a big database?

827


How to handle data if f table are more than one and each table contain thousands of entries?

2002


What is the purpose of database?

818


What is metadata in dbms?

903


how you will identify the mapping level bottleneck ? if there is a mapping level bottleneck then how will you try to improve the mapping

1852


What are the main components of a database in healthcare?

818


How is a database related to a table?

907


What are the advantages and disadvantages of views in the database?

989


What are the different types of languages that are available in the dbms?

974


What do you mean by Correlated subquery in database?

940


What do you understand by data redundancy?

856


What is join? Mention its types.

973