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 119 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 :)

milbourne11

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

« previous next »
 

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?

In 1886, William Bates reported on the discovery of a substance produced by the adrenal gland that turned out to be epinephrine (adrenaline). In 1904, this drug was first artificially synthesized by Friedrich Stolz.

Did you know?

A strange skin disease referred to as Morgellons has occurred in the southern United States and in California. Symptoms include slowly healing sores, joint pain, persistent fatigue, and a sensation of things crawling through the skin. Another symptom is strange-looking, threadlike extrusions coming out of the skin.

Did you know?

You should not take more than 1,000 mg of vitamin E per day. Doses above this amount increase the risk of bleeding problems that can lead to a stroke.

Did you know?

About 600,000 particles of skin are shed every hour by each human. If you live to age 70 years, you have shed 105 pounds of dead skin.

A revised animal phylogeny based on molecular data of SSU rRNA A revised animal phylogeny based on molecular data of SSU rRNA
The internal organization of cells, tissues, organs, and organ systems in a mammal. The internal organization of cells, tissues, organs, and organ systems in a mammal.
Physical assessment is one component of the nursing database Physical assessment is one component of the nursing database
Development of the Reproductive Systems Development of the Reproductive Systems
Doty's data show a very rapid drop in late adulthood in the ability to identify smells Doty's data show a very rapid drop in late adulthood in the ability to identify smells
Find a quadractic equation that models the data in standard form Find a quadractic equation that models the data in standard form
Video: Sickle Cell Anemia

For a complete list of videos, visit our video library