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
Can you explain different types of joins?
What is policy based management (pbm)? : sql server database administration
How do use Having,Group by,Group function in SQL?
What happens if null values are involved in string operations?
What does normalization do to data?
What is dimension table? : sql server analysis services, ssas
Does hive support indexing?
what is difference between NULL and ISNULL in SQL Server 2008?
Can group functions be used in the order by clause in ms sql server?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What is indexed view? How to create it?
What are two difference between sql azure and azure tables?
How to add code to the existing article (using improve article)?
What factors you will consider calculating the storage requirement for that view?
What is a result set object returned by mssql_query()?