what is normalization?
what is denormalization?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / chethan sy
Normalization is a process of removing redundancy from the
tables.
De-normalization is introducing redundancy.
Is This Answer Correct ? | 41 Yes | 6 No |
Answer / koti
In relational database design, the process of organizing
data to minimize redundancy. Normalization usually involves
dividing a database into two or more tables and defining
relationships between the tables. The objective is to
isolate data so that additions, deletions, and modifications
of a field can be made in just one table and then propagated
through the rest of the database via the defined relationships.
De-normalization is introducing redundancy.
Is This Answer Correct ? | 12 Yes | 4 No |
Answer / srinivas
Normalization is the process of eliminating the duplicate , inconsistent data in the database..
As well denormalization is the process of introducing the redundancy to the data
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / hari
Normalization - is the process of desing of the datamodel
and effocential storre the data in database
Is This Answer Correct ? | 10 Yes | 8 No |
Answer / ranjeet
normalization is used to remove data redundancy and
inconsitancy and we can perform the indexing,serching and
shorting the data in very easy manner
Is This Answer Correct ? | 5 Yes | 3 No |
Answer / sarika desai
Normalization is a concept of Eliminating data redundancy,
Improve database performance & Index Improvement.
De-normalization is the process of attempting to optimize
the performance of a database by adding redundant data.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / abdul quadir parihar
Normalization is the process of decomposition of complex
data in to simple way.
Denormalization is basically applied in the case the
database is over-normalised and no. of joins required to
fetch the data are too much. It is a purposeful redundancy
of some of the data to avoid the overhead of joins.
Is This Answer Correct ? | 5 Yes | 5 No |
Normalization is the process of decomposition of complex
data in to simple way.
Denormalization is vice versa.
Is This Answer Correct ? | 8 Yes | 16 No |
Explain indexed views?
What is the syntax to execute the sys.dm_db_missing_index_details?
How to define and use table alias names in ms sql server?
What are subqueries in sql server? Explain its properties.
Do you know what are the steps to process a single select statement?
What is the appropriate number of test cases that you can write on a database?
What are the grouping functions?
When do u use clustered index and non-clustered index?
What is multi-statement table-value user-defined function?
Accidentally i deleted my table. How can i get that table?
What are the two types of concurrency?
How do SQL server 2000 and XML linked?