Interested to Buy Any Domain ? << Click Here >> for more details...
what is normalization?
what is denormalization?
- 9 Answers
- 35103 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 copy sysdatabase file from c: Drive to D: Drive in SQL Server.
How do we return a record set from a Stored Procedure in SQl server 2000?
Will count(column) include columns with null values in its count?
How to drop an existing user defined function in ms sql server?
how to get 25th row in any table in sqlserver can u tell me syntax
Explain what is log shipping?
What's new in sql management studio for sql server? : sql server management studio
What is @@rowcount in sql?
Define views.
WHAT OPERATOR PERFORMS PATTERN MATCHING?
2 Answers CarrizalSoft Technologies, CTS,
What is extent? Types of extents?
select empid empname from employee What is the result for the about query?
-
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)
