The objective of this assignment is to introduce the student to the concept of the data model and how it is navigated for ad hoc querying. It is assumed that students will be familiar with basic data manipulation techniques. Business Context: Sprott Fishing Supplies is a retailer of fishing supplies with a number of stores across Canada. Customers can sign up for a loyalty card for incentives and most due. This allows Sprott to track customer transactions. Customers can purchase goods by going to the store where inventory is on hand. They may wish to order on line or from a catalogue that is sent to customers once a year. Management has hired you as a consultant to perform analytics by looking at the transactional history and answering some of their questions