what is difference between normalization and
denormalization.
in normalization all tables are normalizad format or not.
what r the types of indexes are there.
what is difference b/w bitmap,b-tree,unique and function
based indexes.

Answer Posted / 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"

Is This Answer Correct ?    7 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

write a C program that will determine whether a department -store customer ha exceeded the credit limit on a charge account. For each customer, the following facts are available: a. Account number (an integer) b. Balance at the beginning of the month c. Total of all items charged by this customer this month d. Total of all credits applied to this customer's account this month e. allowed credit limit The program should used a while statement to input each of this facts,calculate the new balance (=beginning balance=charges credits) and determine whether the new balance exceeded,the program should display the customer's account number, credit limit, new balance and the message "Credit Limit Exceeded".

2901


write brief notes and examples on the following terms 1. trade liberalisation 2. Structural Adjustment Program 3. Balanced development 4. NIEO

1991


How did you go about it?

879


(b) Define the terms: field, record, table and database.

1601


How will you motivate workers to strive wiilingly in a target based industry.

1673






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

1524


A. What factor account for the resurgence of interest in Operation Management today? B What strategies are used by supermarkets, airlines, hospitals, banks, and cereal Manufacturers to influence demand.

22651


Why would you choose Supply Chain or Logistic as a career ??

3105


What is Business devlopment?

1432


Is there any impact of the slowdown in the west on the business that your organization gets?

561


What do u want to change in this world?

1452


which companies in nifty

1494


how about ibm(international business management) specialization in MBA?What are the future in it?what are the sources to upgrade it?

2528


How did you develop different types of people?

655


i have completed my cetifictae iv in business and doing deploma of business. after doing these course which deploma course is suitable for me as well as i can get pr? can i do certificate iii in automotive if i can after completing this couse how much score i have to socre to apply the pr? pls honestly adivce me ......................

1591