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
What are string functions in sql?
what is sql in mysql? : Sql dba
Which is better join or inner query?
What can sql server reporting services do?
What are reports usually used for?
How to display the records between two range in Oracle SQL Plus?
how can we optimize or increase the speed of a mysql select query? : Sql dba
what is the functionality of the function htmlentities? : Sql dba
How do I create a memory optimized filegroup?
Enlist the advantages of sql.
Is sql a backend language?
what is dbms? : Sql dba
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
What schema means?
How to load data with sql*loader?
