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

scottmt

  • Member
  • Posts: 322
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

People with high total cholesterol have about two times the risk for heart disease as people with ideal levels.

Did you know?

Eating carrots will improve your eyesight. Carrots are high in vitamin A (retinol), which is essential for good vision. It can also be found in milk, cheese, egg yolks, and liver.

Did you know?

Glaucoma is a leading cause of blindness. As of yet, there is no cure. Everyone is at risk, and there may be no warning signs. It is six to eight times more common in African Americans than in whites. The best and most effective way to detect glaucoma is to receive a dilated eye examination.

Did you know?

About 3.2 billion people, nearly half the world population, are at risk for malaria. In 2015, there are about 214 million malaria cases and an estimated 438,000 malaria deaths.

Did you know?

Lower drug doses for elderly patients should be used first, with titrations of the dose as tolerated to prevent unwanted drug-related pharmacodynamic effects.

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
The immune response results from activation of the humoral and cell-mediated immune systems The immune response results from activation of the humoral and cell-mediated immune systems
Summary of Homologous Structures of the Female and Male Reproductive Systems Summary of Homologous Structures of the Female and Male Reproductive Systems
Describe the Conceptual Forecasting Framework in your own words. Describe the Conceptual Forecasting Framework in your own words.
Difference between the house and the senate Difference between the house and the senate
Video: Retina

For a complete list of videos, visit our video library