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
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".
write brief notes and examples on the following terms 1. trade liberalisation 2. Structural Adjustment Program 3. Balanced development 4. NIEO
How did you go about it?
(b) Define the terms: field, record, table and database.
How will you motivate workers to strive wiilingly in a target based industry.
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
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.
Why would you choose Supply Chain or Logistic as a career ??
What is Business devlopment?
Is there any impact of the slowdown in the west on the business that your organization gets?
What do u want to change in this world?
which companies in nifty
how about ibm(international business management) specialization in MBA?What are the future in it?what are the sources to upgrade it?
How did you develop different types of people?
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 ......................