Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Consider your local video rental store. It certainly has an operational database

ID: 354487 • Letter: C

Question

Consider your local video rental store. It certainly has an operational database to support its online transaction processing (OLTP). The operational database supports such things as adding new customers, renting videos (obviously), ordering videos, and a host of other activities. Now, assume that the video rental store also uses that same database for online analytical processing (OLAP) in the form of creating queries to extract meaningful information. If you were the manager of the video rental store, what kinds of queries would you build? What answers are you hoping to find?
Consider your local video rental store. It certainly has an operational database to support its online transaction processing (OLTP). The operational database supports such things as adding new customers, renting videos (obviously), ordering videos, and a host of other activities. Now, assume that the video rental store also uses that same database for online analytical processing (OLAP) in the form of creating queries to extract meaningful information. If you were the manager of the video rental store, what kinds of queries would you build? What answers are you hoping to find?

Explanation / Answer

Below are the queries that I would build for analysis of data for meaningful insights -

1. Sales of videos by categories or genres viz. action, comedy, horror and thriller, drama, romance etc.

2. Sales of videos by new customers and sales by existing customers.

3. Number of orders and quantity per each rental order

The answers that I would hope to find include -

1. Sales estimate by category based on which the videos for the specific category are stocked more

2. By understanding the sales by new or existing customers, the marketing strategy can be planned either to attract new customers or retain and bosst sales from existing customers.

Related Questions

Consider unlabeled, rooted binary trees. We can compress such trees: whenever th
Question #647974
Consider use object in the figure above. These are two faces acting on it, Which
Question #2221655
Consider use of a Student\'s distribution to test the difference of means for in
Question #3242461
Consider use of a Student\'s distribution to test the difference of means for in
Question #3257178
Consider using Python to create a class that represent disk based storage. Write
Question #3678854
Consider using data stream based prefetching to improve memory access in a data
Question #3773058
Consider using radix sort for sorting the following numbers: 477, 744, 447, 774
Question #3583249
Consider using the following Card class that represents a general type of member
Question #653430
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote

Navigate

Previous
Consider your industry -- how does the The Internet of Things (IoT) and Big Data
Next
Consider your lunch time trip again(figure 2.1) For how many seconds did you acc

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.