Interested to Buy Any Domain ? << Click Here >> for more details...
What is denormalization and when would you go for it?
- 9 Answers
- 39257 Views
- NBP, I also Faced
- E-Mail Answers
Answer Posted / niraj kumar
Industrial experience---->
Denormalization or Normalization both we use on databse so
that any one can filter as well as retrive the data from
the tabel easily.
Denormalization - As the name suggest it is a reverse
process of normalization, means we fill some redundant data
in table so that user can retrive easily.
But actualy we use the major functionality of normalization
of higher normal form(BCNF, 4TH NF ,5TH NF, DKNF) in lower
normal form (1st and 2nd) because higher normal forms are
so costly to use, thats why we use denormalization to
reduce the cost of normalization.
| Is This Answer Correct ? | 17 Yes | 2 No |
Post New Answer View All Answers
How can I detect whether a given connection is blocked?
How would you design a database for an online site, which would average a million hits a day?
Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.
Explain about the storage and physical database design?
How can you log an error to the server event log from a stored procedure?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
What is normalization? Explain different levels of normalization?
How is data stored in dbms?
Explain about the relational database?
What is data modeling with example?
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
How to read and create .LDC data files which are used by linguatic dictionary.
Explain the role of indexing in databases?
Explain about normal forms?
Explain about a primary key?
