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 is an alias command?
What is t-sql? : Transact sql
Explain clause in sql?
Can instead of triggers be used to fire once for each statement on a view?
What is data control language (dcl)?
What is the function that is used to transfer a pl/sql table log to a database table?
Which is faster count (*) or count 1?
Explian rowid, rownum? What are the psoducolumns we have?
What is the difference between join and natural join?
What is the difference between inner join and left join?
What are the different types of database management systems?
What are the different ways to optimize a sql query?
what is view? : Sql dba
How do you sort in sql?
What is left join in sql?