What is Normalization ?
Answer Posted / kannan
Defination : Normalization is the process of efficiently
organizing data in a database. There are two goals of the
normalization process: eliminating redundant data (for
example, storing the same data in more than one table) and
ensuring data dependencies make sense (only storing related
data in a table). Both of these are worthy goals as they
reduce the amount of space a database consumes and ensure
that data is logically stored. There are several benefits
for using Normalization in Database.
Benefits :
Eliminate data redundancy
Improve performance
Query optimization
Faster update due to less number of columns in one table
Index improvement
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How do I escape a reserved word in oracle?
List the various oracle database objects?
How to define and use table alias names in oracle?
Does oracle charge for java?
Is postgres faster than oracle?
Compare and contrast between sql and sql server and explain its various functions?
How do I connect to oracle?
Design database draw er diagram for a certain scenario ?
How to convert a string to a date in oracle database?
How can I create database in oracle?
What are the different pseudo commands? Explain in general?
How to retrieve values from data fields in record variables?
How to use existing values in update statements using oracle?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
What are privileges and grants?