Assignment 5 provides experience writing PostgreSQL statements to generate input for data mining algorithms used for association rules and classification. All problems use the Inventory data warehouse tables. Each problem has equal value of 10 points. For each problem, you should adapt templates and examples given in the notes. Each problem associates with a similar problem in the class notes. The textbook does not cover this material as it was developed after the last edition of the textbook. I doubt that you will find other sources as it is largely original material.

Problem 1: Baskets containing item sets of two items Write a SELECT statement to generate baskets identified by the combination of customer vendor key, date key, and branch plant key for shipments (TransTypeKey = 5). Each row should contain the basket identifying columns and a combination of two items containing item master key values. Eliminate permutations of basket items. Order the result by customer vendor key, date key, branch plant key, and the first item.

Problem 2: Baskets containing item sets of three items Write a SELECT statement to generate baskets identified by the combination of customer vendor key, date key, and branch plant key for shipments (TransTypeKey = 5). Each row should contain the basket identifying columns and a combination of three items containing item master key values. Eliminate permutations of basket items. Order the result by customer vendor key, date key, and branch plant key