when normalization is required

Answer Posted / shahnaz

Normalization is used to improve the performance of database and is applied in the last step of logical database design.The Goal of Normalization is to
1.Eliminate the duplicate data from table
2.Ensure data dependency

we can achieve this by creating multiple tables for each set and by creating primary and foreign keys and building relationship between the newly created tables.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the differences among rownum, rank and dense_rank? : Sql dba

744


What is multiple partition?

698


What is a nested table in word?

705


what is isam? : Sql dba

769


What does trigger mean in slang?

736






What is a unique constraint?

811


What found sql?

703


What is date functions?

729


What is the difference between microsoft sql and mysql?

709


What is 19 null in sql?

703


what is user defined functions? : Sql dba

744


Can we use threading in pl/sql?

712


Explain the types of joins in sql?

737


How do you respond to dementia behavior?

723


is mysql query is case sensitive? : Sql dba

775