This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: Describe the data update difference between operational and analytical database systems. What ... (Read 38 times)

panfilo

  • Hero Member
  • *****
  • Posts: 572
on: Jul 7, 2018
Describe the data update difference between operational and analytical database systems.
 
  What will be an ideal response?

Question 2

Why is the following query invalid:SELECT productname, COUNT ()FROM PRODUCT;
 
  What will be an ideal response?


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

emilymalinowski12

  • Sr. Member
  • ****
  • Posts: 338
Reply #1 on: Jul 7, 2018
Answer to Question 1

Data in operational systems is regularly updated by the users. In operational databases, in addition to issuing queries for the retrieval of data, users routinely insert, modify, and delete data. On the other hand, the end users of analytical databases are only able to retrieve data, and updates of the data by the end users are not allowed.

Answer to Question 2

The reason this query is invalid is that aggregate functions, such as COUNT(), give results across multiple records, and this result cannot be mixed with column values of individual records. The query would have worked if it ended with the 'GROUP BY productname' clause.


panfilo

  • Member
  • Posts: 572
Reply 2 on: Jul 7, 2018
YES! Correct, THANKS for helping me on my review

AmberC1996

  • Member
  • Posts: 317
Reply 3 on: Yesterday
Wow, this really help

« previous next »
 

Did you know?

In the United States, there is a birth every 8 seconds, according to the U.S. Census Bureau's Population Clock.

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?

In most cases, kidneys can recover from almost complete loss of function, such as in acute kidney (renal) failure.

Did you know?

Despite claims by manufacturers, the supplement known as Ginkgo biloba was shown in a study of more than 3,000 participants to be ineffective in reducing development of dementia and Alzheimer’s disease in older people.

Did you know?

In the ancient and medieval periods, dysentery killed about ? of all babies before they reach 12 months of age. The disease was transferred through contaminated drinking water, because there was no way to adequately dispose of sewage, which contaminated the water.

A health history is essential in collecting subjective data about metabolic acidosis. A health history is essential in collecting subjective data about metabolic acidosis.
The Circulatory and Lymphatic Systems Blood and lymph are fluids that circulate throughout the body The Circulatory and Lymphatic Systems Blood and lymph are fluids that circulate throughout the body
Difference Between Solar and Sidereal Day Difference Between Solar and Sidereal Day
Comparison of Somatic and Autonomic Nervous Systems Comparison of Somatic and Autonomic Nervous Systems
Sheridan Motors is a car dealership that would like to investigate if there is a difference in ... Sheridan Motors is a car dealership that would like to investigate if there is a difference in ...
Type II curve. Mortality does not vary with age. Data for five-lined skink (Eumeces fasciatus). Type II curve. Mortality does not vary with age. Data for five-lined skink (Eumeces fasciatus).
Video: Role of ATP in muscle movement

For a complete list of videos, visit our video library