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 131 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
Wow, this really help

brbarasa

  • Member
  • Posts: 308
Reply 3 on: Yesterday
Excellent

« previous next »
 

Did you know?

Alzheimer's disease affects only about 10% of people older than 65 years of age. Most forms of decreased mental function and dementia are caused by disuse (letting the mind get lazy).

Did you know?

The average person is easily confused by the terms pharmaceutics and pharmacology, thinking they are one and the same. Whereas pharmaceutics is the science of preparing and dispensing drugs (otherwise known as the science of pharmacy), pharmacology is the study of medications.

Did you know?

The Centers for Disease Control and Prevention has released reports detailing the deaths of infants (younger than 1 year of age) who died after being given cold and cough medications. This underscores the importance of educating parents that children younger than 2 years of age should never be given over-the-counter cold and cough medications without consulting their physicians.

Did you know?

Automated pill dispensing systems have alarms to alert patients when the correct dosing time has arrived. Most systems work with many varieties of medications, so patients who are taking a variety of drugs can still be in control of their dose regimen.

Did you know?

The Centers for Disease Control and Prevention (CDC) was originally known as the Communicable Disease Center, which was formed to fight malaria. It was originally headquartered in Atlanta, Georgia, since the Southern states faced the worst threat from malaria.

Physical assessment is one component of the nursing database Physical assessment is one component of the nursing database
A pharmacist can explain to a patient why medication may look different and ensure the correct ... A pharmacist can explain to a patient why medication may look different and ensure the correct ...
Mechanisms to Explain the Effects of Massage Mechanisms to Explain the Effects of Massage
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 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: Tuberculosis Testing

For a complete list of videos, visit our video library