Answer Posted / pragyan
database normalization is a data design and organization process applied to data structures based on rules that help building ralational databases.and usually it involves dividing a database into two or more tables and defining relationships between the tables.
de-normalization is the process of attempting to optimize the performance of a database by adding redundant data..
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a hint?
Is sql server implemented as a service or an application? : Sql server database administration
What is an index in a database?
Can you please differentiate between a primary key and a unique key?
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
Explain a checkpoint?
What are the new data types are introduced in sql 2000?
What is openxml in sql server?
Why I am getting this error when dropping a database in ms sql server?
Ways to improve the performance of a SQL Azure Database?
What happens if you delete a table that is used by a view?
How to use clusters?
Explain what role entity and relationship play in an ER diagram.
What is the difference between truncate and delete commands?
What are the dis_advantages of stored procedures, triggers, indexes?