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

adf223

  • Member
  • Posts: 304
Reply 3 on: Yesterday
Gracias!

« previous next »
 

Did you know?

There can actually be a 25-hour time difference between certain locations in the world. The International Date Line passes between the islands of Samoa and American Samoa. It is not a straight line, but "zig-zags" around various island chains. Therefore, Samoa and nearby islands have one date, while American Samoa and nearby islands are one day behind. Daylight saving time is used in some islands, but not in others—further shifting the hours out of sync with natural time.

Did you know?

The first monoclonal antibodies were made exclusively from mouse cells. Some are now fully human, which means they are likely to be safer and may be more effective than older monoclonal antibodies.

Did you know?

The horizontal fraction bar was introduced by the Arabs.

Did you know?

Acetaminophen (Tylenol) in overdose can seriously damage the liver. It should never be taken by people who use alcohol heavily; it can result in severe liver damage and even a condition requiring a liver transplant.

Did you know?

If you could remove all of your skin, it would weigh up to 5 pounds.

A revised animal phylogeny based on molecular data of SSU rRNA A revised animal phylogeny based on molecular data of SSU rRNA
2006 Data:Top 25 Substances Involved in Human Exposures 2006 Data:Top 25 Substances Involved in Human Exposures
Data from more than 22,000 men over the age of 40, showing the relationship between birth weight and ... Data from more than 22,000 men over the age of 40, showing the relationship between birth weight and ...
Systems and Organs of the Human Body Systems and Organs of the Human Body
Major Wind Systems: Katabatic Winds Major Wind Systems: Katabatic Winds
How to fit an exponential model to data How to fit an exponential model to data
Video: System organization - PPM system types (Somatic, Autonomic & Enteric) and Reflex arc types

For a complete list of videos, visit our video library