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 |
How to turn on the mssql api module in php?
What is scrollable cursor?
Can sql servers linked to other servers like oracle?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
What is normalization according to you and explain its different levels?
What is named calculation? : sql server analysis services, ssas
What is cross join in sql server joins?
Can the query output be sorted by multiple columns in ms sql server?
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
How you can move data or databases between servers and databases in sql server?
How dts is used to extract, transform and consolidate data?
SQL stops working in every 15 days displaying message that database log file is full. Log file size is 3.95 GB. It is happening after shrinking the database also. What is solution to overcome this problem. Please help me as it's urgent.