This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: Explain why someone would denormalize a database and the dangers of doing so. What will be an ... (Read 53 times)

nramada

  • Hero Member
  • *****
  • Posts: 580
on: Jul 7, 2018
Explain why someone would denormalize a database and the dangers of doing so.
 
  What will be an ideal response?

Question 2

When NULL is used as a criteria it can be accessed using operators such as = .
 
  Indicate whether the statement is true or false


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

rleezy04

  • Sr. Member
  • ****
  • Posts: 322
Reply #1 on: Jul 7, 2018
Answer to Question 1

Denormalization is done to improve performance. Sometimes it is necessary to rejoin tables that were separated to provide users with the timely experience they expect. However, denormalizing a database has its dangers. By denormalizing, a database administrator opens up the database to all the anomalies and errors that the normal forms were designed to prevent. Denormalization should be done carefully, with caution and only after all other performance tuning has been tried.

Answer to Question 2

FALSE


nramada

  • Member
  • Posts: 580
Reply 2 on: Jul 7, 2018
YES! Correct, THANKS for helping me on my review

meow1234

  • Member
  • Posts: 333
Reply 3 on: Yesterday
Wow, this really help

« previous next »
 

Did you know?

In 2010, opiate painkllers, such as morphine, OxyContin®, and Vicodin®, were tied to almost 60% of drug overdose deaths.

Did you know?

The B-complex vitamins and vitamin C are not stored in the body and must be replaced each day.

Did you know?

Cucumber slices relieve headaches by tightening blood vessels, reducing blood flow to the area, and relieving pressure.

Did you know?

Though the United States has largely rejected the metric system, it is used for currency, as in 100 pennies = 1 dollar. Previously, the British currency system was used, with measurements such as 12 pence to the shilling, and 20 shillings to the pound.

Did you know?

There are more sensory neurons in the tongue than in any other part of the body.

Draw and label a diagram and explain how a factor-dependent transcription (rho-dependent) terminator Draw and label a diagram and explain how a factor-dependent transcription (rho-dependent) terminator
E9-23 Prepare income statements Explain the difference in operating income E9-23 Prepare income statements Explain the difference in operating income
Social scientists have not done well at devising theories to explain lovely romantic moments Social scientists have not done well at devising theories to explain lovely romantic moments
Please fully explain in detail Please fully explain in detail
Explain how it can be desirable from an intertemporal perspective for a country run a current ... Explain how it can be desirable from an intertemporal perspective for a country run a current ...
Please explain the different Rf values for xanthophyll’s in paper chromatography compared to ... Please explain the different Rf values for xanthophyll’s in paper chromatography compared to ...
Video: Acid-base imbalances - respiratory acidosis and alkalosis

For a complete list of videos, visit our video library