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

Author Question: Describe the data redundancy difference between operational and analytical database systems. What ... (Read 106 times)

gbarreiro

  • Hero Member
  • *****
  • Posts: 566
on: Jul 7, 2018
Describe the data redundancy difference between operational and analytical database systems.
 
  What will be an ideal response?

Question 2

Two entities can be related via multiple different binary relationships.
 
  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

juwms

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

Reducing the redundancy of information is a major goal of operational databases. One of the main reasons for minimizing the redundancy in operational databases is to eliminate the possibility of update anomalies. However, the updating of data by the end users is not allowed in analytical databases, and therefore, there is no particular danger of update anomalies. Hence, eliminating redundancy is not as critical in analytical databases as it is in operational databases.

Answer to Question 2

TRUE


gbarreiro

  • Member
  • Posts: 566
Reply 2 on: Jul 7, 2018
Great answer, keep it coming :)

pangili4

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

« previous next »
 

Did you know?

The first successful kidney transplant was performed in 1954 and occurred in Boston. A kidney from an identical twin was transplanted into his dying brother's body and was not rejected because it did not appear foreign to his body.

Did you know?

Egg cells are about the size of a grain of sand. They are formed inside of a female's ovaries before she is even born.

Did you know?

It is widely believed that giving a daily oral dose of aspirin to heart attack patients improves their chances of survival because the aspirin blocks the formation of new blood clots.

Did you know?

Giardia is one of the most common intestinal parasites worldwide, and infects up to 20% of the world population, mostly in poorer countries with inadequate sanitation. Infections are most common in children, though chronic Giardia is more common in adults.

Did you know?

Hippocrates noted that blood separates into four differently colored liquids when removed from the body and examined: a pure red liquid mixed with white liquid material with a yellow-colored froth at the top and a black substance that settles underneath; he named these the four humors (for blood, phlegm, yellow bile, and black bile).

This chart shows the various lines of responsibility and how they differ in presidential and parliam This chart shows the various lines of responsibility and how they differ in presidential and parliam
Systems of humans Systems of humans
How to create a frequency table and histogram from raw data How to create a frequency table and histogram from raw data
How to describe transformations of a sinusoidal function (y=a*sin⁡b(x−c)+d) How to describe transformations of a sinusoidal function (y=a*sin⁡b(x−c)+d)
Other Body Systems Help You Use Digested Nutrients Body systems Other Body Systems Help You Use Digested Nutrients Body systems
Sensitivity study for facial difference Sensitivity study for facial difference
Video: Types of synapses - electrical & chemical

For a complete list of videos, visit our video library