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 76 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
YES! Correct, THANKS for helping me on my review

ryhom

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

« previous next »
 

Did you know?

More than nineteen million Americans carry the factor V gene that causes blood clots, pulmonary embolism, and heart disease.

Did you know?

Once thought to have neurofibromatosis, Joseph Merrick (also known as "the elephant man") is now, in retrospect, thought by clinical experts to have had Proteus syndrome. This endocrine disease causes continued and abnormal growth of the bones, muscles, skin, and so on and can become completely debilitating with severe deformities occurring anywhere on the body.

Did you know?

In most cases, kidneys can recover from almost complete loss of function, such as in acute kidney (renal) failure.

Did you know?

The people with the highest levels of LDL are Mexican American males and non-Hispanic black females.

Did you know?

Liver spots have nothing whatsoever to do with the liver. They are a type of freckles commonly seen in older adults who have been out in the sun without sufficient sunscreen.

Energy budget for a temperate deciduous forest (data from Gosz et al. 1978). Energy budget for a temperate deciduous forest (data from Gosz et al. 1978).
Commonly Used Equivalents for the Apothecary and Metric Systems Cont Commonly Used Equivalents for the Apothecary and Metric Systems Cont
Operational Control Operational Control
How to create a frequency table and histogram from raw data How to create a frequency table and histogram from raw data
Other Body Systems Help You Use Digested Nutrients Body systems Other Body Systems Help You Use Digested Nutrients Body systems
Prefilled Unit-Dose Systems Prefilled Unit-Dose Systems
Video: Electromagnetic Spectrum, Chlorophyll and Pigment & Light

For a complete list of videos, visit our video library