DEFINING QUERIES FOR A VIDEO RENTAL STORE
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?