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 73 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

nothere

  • Member
  • Posts: 324
Reply 3 on: Yesterday
:D TYSM

« previous next »
 

Did you know?

Acute bronchitis is an inflammation of the breathing tubes (bronchi), which causes increased mucus production and other changes. It is usually caused by bacteria or viruses, can be serious in people who have pulmonary or cardiac diseases, and can lead to pneumonia.

Did you know?

The shortest mature adult human of whom there is independent evidence was Gul Mohammed in India. In 1990, he was measured in New Delhi and stood 22.5 inches tall.

Did you know?

Everyone has one nostril that is larger than the other.

Did you know?

A cataract is a clouding of the eyes' natural lens. As we age, some clouding of the lens may occur. The first sign of a cataract is usually blurry vision. Although glasses and other visual aids may at first help a person with cataracts, surgery may become inevitable. Cataract surgery is very successful in restoring vision, and it is the most frequently performed surgery in the United States.

Did you know?

It is believed that the Incas used anesthesia. Evidence supports the theory that shamans chewed cocoa leaves and drilled holes into the heads of patients (letting evil spirits escape), spitting into the wounds they made. The mixture of cocaine, saliva, and resin numbed the site enough to allow hours of drilling.

Pulmonary function test: spirometry. (a) Normal respiratory volumes, as measured during spirometry. Pulmonary function test: spirometry. (a) Normal respiratory volumes, as measured during spirometry.
Zonal wind speeds on Uranus. Shaded areas show the southern collar and its future northern counterpa Zonal wind speeds on Uranus. Shaded areas show the southern collar and its future northern counterpa
Review of Systems ROS Cont. Review of Systems ROS Cont.
Eukaryotic signal transduction systems involving membrane receptors (1–5)/ second messengers (1-4) Eukaryotic signal transduction systems involving membrane receptors (1–5)/ second messengers (1-4)
Other Body Systems Help You Use Digested Nutrients Body systems Other Body Systems Help You Use Digested Nutrients Body systems
data data
Video: Phases of an Action Potential - Resting Potential, Threshold, Rising, Falling, & Recovery Phases

For a complete list of videos, visit our video library