At a fundamental level of analysis, we can conceive of the ‘point of sale’ data capture...

At a fundamental level of analysis, we can conceive of the ‘point of sale’ data capture of a business event, transaction processing, data storage, and ultimately data analysis and production of a business intelligence (BI) report. Explain how this overall sequence of activities occurs. Your explanation should focus the role of the TPS (1 mark), the two major processing options that may be used by the TPS , the role and major limitation of the production database (1 mark), and finally the role of the OLAP database (1 mark).

Expert Solution

ANS:

Role of TPS ( Transaction Processing System)

TPS processes the companys'business transaction & support the day-to-day operation of an organisation. It records the Non- query transactions in the database & produces the Output in form of reports of transaction. The major role or activities involved in a TPS are -

capturing the data & organising the files in the database
Processing the files using the application software
Generating informations in form of reports
Processing queries of the organisation.

The two major processing options that may be used by the TPS are -

Batch Processing - In this recording of transaction is done batch-wise i.e the transactions are accumulated over a period of time & processed as a batch wise or as a single unit.
Real-Time Processing - In this the transactions are being recorded as & when they incurred. It is also referred as Online Transaction processing (OLTP).

Role of Production Database -

Production Database contains the details of production task which ensures availability, usability & efficiency. It's general role is capacity Planning, performance monitoring, utilisation of resources etc.

Limitations of Production Database -

These database are complex, Difficult to use & time consuming
Involves High Conversion costs.

Role of the OLAP database are -

Enables the users to analyse the multi-dimesional data from different views.
Provides the capability of fast processing of data by the interactive & consistent interfaces.

jeff jeffy answered 2 years ago

1. Point-of-Sale System: We have two companies that can implement a point-of-sale system. Both with cost...

1. Point-of-Sale System: We have two companies that can implement a point-of-sale system. Both with cost $200,000 to implement. Company A says we will receive the following returns on our investment: Year 1: $85,000; Year 2: $25,000; Year 3: $30,000; Years 4–10: $10,000. Company B says we will receive the following returns on our investment: Year 1: $30,000; Year 2: $25,000; Year 3: $85,000; Years 4–10: $10,000. Using the payback method, which company should we use and Why?

What are the properties of ratio level data and what can we do with it that...

What are the properties of ratio level data and what can we do with it that we cannot do with other levels of measurement?

How can fundamental analysts trade on the basis of an accounting analysis?

We have been requested by a large retailer to submit a bid for a new point-of-sale...

We have been requested by a large retailer to submit a bid for a new point-of-sale credit checking system. The system would be installed, by us, in 89 stores per year for three years. We would need to purchase $1,300,000 worth of specialized equipment. This will be depreciated at a 20% CCA rate. We will sell it in three years, at which time it will be worth about half of what we paid for it. Labour and material cost to...

how we can choose statistical analysis test based on data type and no of variables? give...

how we can choose statistical analysis test based on data type and no of variables? give me 5 test examples which must include manova and mancova

Thought on working with Data. What can we used data. How can we work with it....

Thought on working with Data. What can we used data. How can we work with it. I need a paragraph

Question 11 (1 point) When we say that a price is below the "market clearing level",we...

Question 11 (1 point) When we say that a price is below the "market clearing level",we imply that: Question 11 options: quantity demanded exceeds quantity supplied. the current price is above the equilibrium price. quantity supplied exceeds quantity demanded. the price of the good is likely to decrease. Save Question 12 (1 point) A movement upward along a supply curve in response to a change in a product's own price is a(n): Question 12 options: increase in supply increase in...

Can fundamental analysis be profitable, or are markets just too efficient to justify the effort? You...

Can fundamental analysis be profitable, or are markets just too efficient to justify the effort? You might be familiar with P/E ratios by now, what has happened to the values for the other relative valuation ratios – that is, the P/BV, P/CF, and P/S ratios?

Explain the market condition under which fundamental analysis can lead to abnormal return

We are planning to use Raid Level-0. We have a data of size 2KB and we...

We are planning to use Raid Level-0. We have a data of size 2KB and we would like to create some blocks where each block will hold 4 Byte. We have total 5 disks named Disk0,Disk1,Disk2,Disk3,Disk4. The block number is starting from Block1. How many blocks will be stored by Disk1? ------------------------------------------------------------------------------------------------------------------------------- We are planning to use Raid Level-0. We have a data of size 2KB and we would like to create some blocks where each block will hold 4...

Question