Interested to Buy Any Domain ? << Click Here >> for more details...
what is normalization?
what is denormalization?
- 9 Answers
- 34815 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 |
What are the diifferences between the ms sql server vs mysql?
What are the differences between DDL, DML and DCL in SQL?
0 Answers ABB, Aspire, Infogain,
How can you control the amount of free space in your index pages?
What is store procedure? How do they work?
How to add an address record into adventureworkslt?
What is sql server database?
Explain different types of collation sensitivity?
What is the command used to get the version of sql server?
List all the types of user-defined functions?
Assume,there are three tables in a database, Can i have both primary key and foreign key for each table in the same database?
How to retrieve data from log files in SQL SERVER ?????
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
