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"

WHAT VISA YOU ARE APPLING FOR

0 Answers  

---

when does communication take place in a business

0 Answers  

---

who is a CEO of Infosys?

5 Answers  

---

Describe a time when you've has to make a decision that was likely to be unpopular with your team

0 Answers   John Clark Motor Group,

---

Case Study Please read the case given below and answer the questions given at the end. One afternoon in June 1972, Rao, industrial engineer of P.M.A. company, was called to the office of his immediate superior V.R. Naik, the production manager. Naik said, “Rao, I want to discuss a situation in the production department. A lot of people feel that Govindan is not the right man for the Assistant Superintendent’s position. The President and others have decided that I have got to fire Govindan or at least move him out of production. Everyone wants to fire Govindan, but I won’t do it to him. I was talking with Bhadra this morning, and we decided that you might be able to make use of Govindan in your department.” Rao was surprised by both the information, and the proposal. Naik concluded his comments with, “Rao, I am asking you to take Govindan. You can say ‘No’. But then he gets fired. I have told Govindan this. Also, Govindan knows that if he goes with you he will take a pay cut. However, I think you can make use of him both to your own and his satisfaction. You are, anyway, carrying out an in-process quality control, and you might be able to make good use of Govindan in view of his long technical experience of production work. Think it over, and let me know by tomorrow.” Rao thought over the matter. PMA company had been a successful enterprise until March 1972 at which time it suffered a sharp decline of profits : sales had fallen off, and production costs had risen. The President adopted three measures which he hoped would improve the condition. First, by creating an Industrial Engineering Department for establishing work standards on all production operations, to determine which manufacturing costs were out of line and where remedial action should be taken. Rao, 28 years old, who had been with the company for two years in the Purchasing department, was selected. Rao had B.E. and MBA degrees to his credit. What he lacked in his business experience he made up by his eagerness to learn. He was ambitious and liked by his associates. He wanted a transfer from Purchasing to Production for better opportunities for advancement. Secondly, he consulted a Management Consultation firm to make a study of the Production Department. They pointed out that the chain of command was too long from Production Manager through Plant Superintendent through Assistant Superintendent to Foremen. They recommended the elimination of the position of Assistant Superintendent. Thirdly, he engaged an Industrial Psychologist to appraise all the Supervisory Personnel. Govindan had been with the company for 20 years since its founding and during this period had worked on every production operation, and his last 11 years had been in supervisory capacity. His manners were rough and aggressive, he had little formal education. The industrial Psychologist’s report about Govindan contained the following points: (i) Evaluation for the position of Assistant Superintendent : Not good enough. (ii) Capacity for good human relations in supervision : Will have friction frequently. (iii) Need for development counseling: Counseling greatly needed. (iv) General evaluation: Govindan had a good ability profile. He suffers from a sense of inferiority. He does not like the responsibility of making decisions. His supervision is that of Autocratic type. Though he has the ability, as far as his personality make-up is concerned, he is out of place in the present position. Questions: 1. What is the problem in the case? Explain. 2. Explain Govindan’s behavior and work experience vis-à- vis the psychologist’s report. 3. How do you see Naik’s suggestion to Rao? Give reasons. 4. What are Rao’s considerations in taking a decision? What should he do? Explain.

0 Answers   HP,

---

mbo was first suggested by

4 Answers  

---

5. Identify & explain the responsibilities of the sender & the responsibilities of the receiver in the communication process.

2 Answers  

---

what is know about bcpl

0 Answers  

---

TELL ME ABOUT THE WAREHOUSING NORMS

0 Answers   LG Soft,

---

What steps did you take?

0 Answers   John Clark Motor Group,

---

What goals do you have in your career?

0 Answers  

---

(a) Describe the My Computer and My Documents folders; identify the elements that are present in every Window.

0 Answers  

---