What is Normalization ?

Answer Posted / hema kumar sunnapu

Database designed based on the E-R model may have some amount of inconsistency, ambiguity and redundancy. To resolve these issues we have to do some amount of refinement is required. This refinement process is called as Normalization.
(OR)
Normalization is the process of efficiently organizing data in database. There are two goals of the normalization process: eliminating redundant data and ensuring data dependency make sense.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are joins, explain all types of joins?

1724


material view and view disadvantages?

635


What would you do with an in-doubt distributed transaction?

1469


What is a nested table?

629


How many categories of data types?

574






How to unlock the sample user account in oracle?

558


How to shutdown your 10g xe server?

618


How do you store pictures in a database?

563


What are the restrictions on external table columns?

552


What are the different types of failures that occur in Oracle database?

603


Why does oracle 9i treat an empty string as null?

539


How can you use check constraints for self referential integrity?

524


How to export data with a field delimiter?

582


How to insert multiple rows with one insert statement in oracle?

571


what's query optimization and without use of IN AND Exist can we get another way data from query

1669