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
What is it’s similarity with sql server?
what is the primary use of the model database? : Sql server administration
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What are trace flags?
What are the different authentication modes in sql server?
Do you know hot add cpu in sql server 2008?
Why use “nolock” in sql server?
Define indexes?
What language is sql server written in?
How to provide values to user defined function parameters?
How to execute the cursor queries with "open" statements?
What is the difference between TRUNCATE and DROP?
What is the template in sql?
What is the difference between Triggers and Stored Procedure?