what is normalization?
what is denormalization?
- 9 Answers
- 33226 Views
- Satyam, I also Faced
- E-Mail Answers
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 run sql server 2005 books online on your local system?
What stored by the model?
How do you open a cluster administrator?
What is a trigger and types of a trigger?
How to Get the last identity value used
Explain what are db_options used for?
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
What is use of except clause?
How to get the definition of a stored procedure back?
What is the openxml statement in sql server?
Explain “not null constraint” in sql server?
How to list all columns in a table using odbc_columns()?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
