what is normalization?
what is denormalization?
Answer Posted / shantanub
Normalization is the process of organizing data in a
database. This includes creating tables and establishing
relationships between those tables according to rules
designed both to protect the data and to make the database
more flexible by eliminating two factors: redundancy and
inconsistent dependency.
| Is This Answer Correct ? | 51 Yes | 5 No |
Post New Answer View All Answers
How to transfer data from a cursor to variables with a "fetch" statement?
What is the difference in accessing db between sql server vs sql azure?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What are different types of join?
What is function of ROLLUP ?
What is attribute hierarchy? : sql server analysis services, ssas
What are the new data types are introduced in sql 2000?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
Give me a SQL Query to find out the second largest company?
How to get the query of a table in sql server?
What are the new features in SQL Server 2005 when compared to SQL Server 2000?
Explain comment on transactions?
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
What is the use of custom fields in report?