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 99 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
Gracias!

sultansheikh

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

« previous next »
 

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?

Hip fractures are the most serious consequences of osteoporosis. The incidence of hip fractures increases with each decade among patients in their 60s to patients in their 90s for both women and men of all populations. Men and women older than 80 years of age show the highest incidence of hip fractures.

Did you know?

The Centers for Disease Control and Prevention (CDC) was originally known as the Communicable Disease Center, which was formed to fight malaria. It was originally headquartered in Atlanta, Georgia, since the Southern states faced the worst threat from malaria.

Did you know?

Though methadone is often used to treat dependency on other opioids, the drug itself can be abused. Crushing or snorting methadone can achieve the opiate "rush" desired by addicts. Improper use such as these can lead to a dangerous dependency on methadone. This drug now accounts for nearly one-third of opioid-related deaths.

Did you know?

About 60% of newborn infants in the United States are jaundiced; that is, they look yellow. Kernicterus is a form of brain damage caused by excessive jaundice. When babies begin to be affected by excessive jaundice and begin to have brain damage, they become excessively lethargic.

Frontal systems Frontal systems
Systems Analysis and Design, 10th Edition Systems Analysis and Design, 10th Edition
River Systems River Systems
A gene map for chromosome 12 from the NCBI database Map Viewer A gene map for chromosome 12 from the NCBI database Map Viewer
A comparison of political systems A comparison of political systems
Some Cofactors in Biological Systems Some Cofactors in Biological Systems
Video: Virtual Enzyme Kinetics & Lineweaver Burk Plot

For a complete list of videos, visit our video library