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 141 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
Great answer, keep it coming :)

daiying98

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

« previous next »
 

Did you know?

More than 30% of American adults, and about 12% of children utilize health care approaches that were developed outside of conventional medicine.

Did you know?

This year, an estimated 1.4 million Americans will have a new or recurrent heart attack.

Did you know?

The Romans did not use numerals to indicate fractions but instead used words to indicate parts of a whole.

Did you know?

Of the estimated 2 million heroin users in the United States, 600,000–800,000 are considered hardcore addicts. Heroin addiction is considered to be one of the hardest addictions to recover from.

Did you know?

Green tea is able to stop the scent of garlic or onion from causing bad breath.

Inverse Relation Between IQ and Disease. Could this explain the Flynn effect? Inverse Relation Between IQ and Disease. Could this explain the Flynn effect?
Historian James Merrell notes several errors in Benjamin West’s famous 1771 painting, William Penn’s Historian James Merrell notes several errors in Benjamin West’s famous 1771 painting, William Penn’s
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
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
Explain the assumptions that must be satisfied in order to validly use the one-way ANOVA ... Explain the assumptions that must be satisfied in order to validly use the one-way ANOVA ...
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: Barriers - eye structures, digestive mucosa, respiratory mucosa & genitourinary mucosa

For a complete list of videos, visit our video library