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 39 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
Thanks for the timely response, appreciate it

aliotak

  • Member
  • Posts: 326
Reply 3 on: Yesterday
:D TYSM

« previous next »
 

Did you know?

Asthma-like symptoms were first recorded about 3,500 years ago in Egypt. The first manuscript specifically written about asthma was in the year 1190, describing a condition characterized by sudden breathlessness. The treatments listed in this manuscript include chicken soup, herbs, and sexual abstinence.

Did you know?

About 600,000 particles of skin are shed every hour by each human. If you live to age 70 years, you have shed 105 pounds of dead skin.

Did you know?

Only one in 10 cancer deaths is caused by the primary tumor. The vast majority of cancer mortality is caused by cells breaking away from the main tumor and metastasizing to other parts of the body, such as the brain, bones, or liver.

Did you know?

Adolescents often feel clumsy during puberty because during this time of development, their hands and feet grow faster than their arms and legs do. The body is therefore out of proportion. One out of five adolescents actually experiences growing pains during this period.

Did you know?

The U.S. Pharmacopeia Medication Errors Reporting Program states that approximately 50% of all medication errors involve insulin.

Physical assessment is one component of the nursing database Physical assessment is one component of the nursing database
E9-23 Prepare income statements Explain the difference in operating income E9-23 Prepare income statements Explain the difference in operating income
Please fully explain the answer with steps Please fully explain the answer with steps
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 ...
A gene map for chromosome 12 from the NCBI database Map Viewer A gene map for chromosome 12 from the NCBI database Map Viewer
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: Pasteur's Experiment

For a complete list of videos, visit our video library