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
How to view existing indexes on an given table using sys.indexes?
What is advantage data architect?
What is a cube? : sql server analysis services, ssas
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
what type of index will get created after executing the above statement? : Sql server database administration
Explain rdbms?
What is normalization of database?
Where is trigger in sql server?
What is clustered primary key?
What is a result set object returned by mssql_query()?
What is query parameter in ssrs?
What are the aggregate and scalar functions?
Define indexes?
Explain temporary table vs table variable by using cursor alternative?
What are different types of table joins?