This topic contains a solution. Click here to go to the answer

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

panfilo

  • Hero Member
  • *****
  • Posts: 572
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
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
Great answer, keep it coming :)


peter

  • Member
  • Posts: 330
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

 

Did you know?

Throughout history, plants containing cardiac steroids have been used as heart drugs and as poisons (e.g., in arrows used in combat), emetics, and diuretics.

Did you know?

In 1844, Charles Goodyear obtained the first patent for a rubber condom.

Did you know?

Approximately one in three babies in the United States is now delivered by cesarean section. The number of cesarean sections in the United States has risen 46% since 1996.

Did you know?

In 2012, nearly 24 milliion Americans, aged 12 and older, had abused an illicit drug, according to the National Institute on Drug Abuse (NIDA).

Did you know?

Cyanide works by making the human body unable to use oxygen.

For a complete list of videos, visit our video library