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
How sql query is executed?
what is the difference between union and union all? : Sql dba
How do I use google cloud in sql?
What is trigger in sql? Explain
Can we insert data into view?
What are the different types of sql commands?
Define sql delete statement.
How do you exit in sql?
What is the difference between a procedure and a function?
What are pl/sql cursor exceptions?
What is spool?
What are basic techniques of indexing?
Can a table have no primary key?
Cite the differences between execution of triggers and stored procedures?
Is natural join same as inner join?