What is normalization and types of normalization?

Answer Posted / aa

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.

Is This Answer Correct ?    204 Yes 40 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to start the command-line sql*plus?

566


What is the difference between instead of trigger and after trigger?

514


how many tables will create when we create table, what are they? : Sql dba

549


What is set transaction?

586


Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

539






What are three advantages to using sql?

555


How do you select unique values in sql?

504


What are the two types of exceptions.

637


how to create a new table in mysql? : Sql dba

554


How do I view an execution plan in sql?

534


What is insert command in sql?

530


Why join is faster than subquery?

603


Why do we use partitions in sql?

549


How can we make an if statement within a select statement?

543


How to return an array from java to pl/sql?

595