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

Missbam101

  • Member
  • Posts: 341
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

Drying your hands with a paper towel will reduce the bacterial count on your hands by 45–60%.

Did you know?

The first successful kidney transplant was performed in 1954 and occurred in Boston. A kidney from an identical twin was transplanted into his dying brother's body and was not rejected because it did not appear foreign to his body.

Did you know?

Most strokes are caused when blood clots move to a blood vessel in the brain and block blood flow to that area. Thrombolytic therapy can be used to dissolve the clot quickly. If given within 3 hours of the first stroke symptoms, this therapy can help limit stroke damage and disability.

Did you know?

Children with strabismus (crossed eyes) can be treated. They are not able to outgrow this condition on their own, but with help, it can be more easily corrected at a younger age. It is important for infants to have eye examinations as early as possible in their development and then another at age 2 years.

Did you know?

It is believed that humans initially contracted crabs from gorillas about 3 million years ago from either sleeping in gorilla nests or eating the apes.

Looking carefully at the scan tool data is very helpful in locating the source of a problem. Looking carefully at the scan tool data is very helpful in locating the source of a problem.
Difference Between Solar and Sidereal Day Difference Between Solar and Sidereal Day
An electron is accelerated from rest through a potential difference. After acceleration the ... An electron is accelerated from rest through a potential difference. After acceleration the ...
data data
Describe the Conceptual Forecasting Framework in your own words. Describe the Conceptual Forecasting Framework in your own words.
Functional divisions of vertebrate nervous systems Functional divisions of vertebrate nervous systems
Video: Interview with Person having Obsessive Compulsive Disorder

For a complete list of videos, visit our video library