Answer / karthikeyan

Denormalization is the process of attempting to optimize the
performance of a database by adding redundant data or by
grouping data.
Normalization is the process of de-composing a relation with
anomalies into a well structured relation.

Answer / samarth

Denormalization is the process of introducing redundancy
into a table by incorporating data from a related table.
Tables are usually denormalized to prevent expensive SQL
join operations between them.

One should always normalize to third-normal form and only
apply denormalization selectively as a last resort if
performance problems are experienced. Remember that
denormalizations is not free and introduces the following
problem into the design:
More disk space is used as the same data is duplicated in
more than one table
DML operations are more expensive as the same data must be
maintained in more than one table
You run the risk that the data can get "out of sync"

Answer / Amit Tripathi

Normalization and denormalization are opposite database design concepts. Normalization aims to reduce data redundancy by organizing tables in a way that minimizes duplicate information and promotes data integrity. In normalized form, each table contains atomic data without any repeating groups or sub-tables. Denormalization, on the other hand, involves duplicating data across multiple tables to improve query performance at the cost of increased redundancy. Normalized databases are not always in normal form (e.g., first normal form, second normal form, third normal form, etc.).

how many universities are there for studying MBA & B- Schoools.

1 Answers  

---

How did you communicate the decision?

1 Answers   John Clark Motor Group,

---

Differentiate between corporate planning and stratigic planning.

1 Answers  

---

reqyured sale tax pattern

1 Answers  

---

financial management what will your out look towards maintenance of liquid assets to ensure that the firm has adequate cash in hand to meet its obligations at all times? i need answer in 5 to 6 pages please help me

1 Answers  

---

Suppose you have done your graduation in science

1 Answers  

---

What was the situation?

1 Answers   John Clark Motor Group,

---

Will retail sector sustain upto 2025

2 Answers  

---

How would you describe yourself?* (In answer, you should write in not more than 200 words addressing your personal qualities,strengths,weaknesses and activities that intertest you. you may also like to touch upon what your parents and friends think of you.)

1 Answers   Diya, State Bank Of India SBI, Touch n Go,

---

Describe Workflow & the special features of it ? Give an illustration of BPM workflow ?

1 Answers  

---

What Do you Mean by Wall Management?

1 Answers   Ernst Young,

---

Up to what time we can show TDS Receivables under Advance Income Tax A/c?

1 Answers   India Infoline, Infoline,

---