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 118 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

xiazhe

  • Member
  • Posts: 331
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

The use of salicylates dates back 2,500 years to Hippocrates's recommendation of willow bark (from which a salicylate is derived) as an aid to the pains of childbirth. However, overdosage of salicylates can harm body fluids, electrolytes, the CNS, the GI tract, the ears, the lungs, the blood, the liver, and the kidneys and cause coma or death.

Did you know?

The shortest mature adult human of whom there is independent evidence was Gul Mohammed in India. In 1990, he was measured in New Delhi and stood 22.5 inches tall.

Did you know?

The highest suicide rate in the United States is among people ages 65 years and older. Almost 15% of people in this age group commit suicide every year.

Did you know?

Immunoglobulin injections may give short-term protection against, or reduce severity of certain diseases. They help people who have an inherited problem making their own antibodies, or those who are having certain types of cancer treatments.

Did you know?

Human neurons are so small that they require a microscope in order to be seen. However, some neurons can be up to 3 feet long, such as those that extend from the spinal cord to the toes.

This modified model of Easton’s systems theory puts government decision makers as the source of pol This modified model of Easton’s systems theory puts government decision makers as the source of pol
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
Please fully explain the answer with steps Please fully explain the answer with steps
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 ...
Explain the myogenic autoregulation of the glomerular filtration rate Explain the myogenic autoregulation of the glomerular filtration rate
A gene map for chromosome 12 from the NCBI database Map Viewer A gene map for chromosome 12 from the NCBI database Map Viewer
Video: Dendrite Animation

For a complete list of videos, visit our video library