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 101 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

Dnite

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

« previous next »
 

Did you know?

HIV testing reach is still limited. An estimated 40% of people with HIV (more than 14 million) remain undiagnosed and do not know their infection status.

Did you know?

Blood is approximately twice as thick as water because of the cells and other components found in it.

Did you know?

Approximately 70% of expectant mothers report experiencing some symptoms of morning sickness during the first trimester of pregnancy.

Did you know?

More than one-third of adult Americans are obese. Diseases that kill the largest number of people annually, such as heart disease, cancer, diabetes, stroke, and hypertension, can be attributed to diet.

Did you know?

Ether was used widely for surgeries but became less popular because of its flammability and its tendency to cause vomiting. In England, it was quickly replaced by chloroform, but this agent caused many deaths and lost popularity.

The cladistic approach from molecular genetic data The cladistic approach from molecular genetic data
Representative vertebrate circulatory systems. Representative vertebrate circulatory systems.
The material safety data sheet (MSDS) for sulfuric acid showing the detailed technical information ... The material safety data sheet (MSDS) for sulfuric acid showing the detailed technical information ...
data data
Common Systems for Direct DNA Repair Common Systems for Direct DNA Repair
Some Cofactors in Biological Systems Some Cofactors in Biological Systems
Video: Optic Nerve and Optic Disk Animation (Part 1 of 2)

For a complete list of videos, visit our video library