What is normalization ?

Answer Posted / seenuvasan.a

It is a process of the analysing the given relation schemas based on their Functional Dependency(FDs) and primary key to achieve the properties,

-> Minimizing redundancy.
-> Minimizing insertion,deletion,and update anomalies.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to call a javascript function from pl sql?

565


How is indexing done in search engines?

531


what are the different index configurations a table can have? : Sql dba

576


what are properties of a transaction? : Sql dba

561


Explain autonomous transaction.

640






What is the sql case statement?

581


What does rownum mean in sql?

558


Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

1688


Can a primary key be a foreign key?

579


How will you distinguish a global variable with a local variable in pl/sql?

626


How do I run a pl sql procedure in sql developer?

516


Differentiate between pl/sql and sql?

619


How can I see all tables in sql?

548


how can we optimize or increase the speed of a mysql select query? : Sql dba

514


table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

3350