By: Dallas Snider | Updated: 2014-03-07 | Comments (3) | Related: > Analysis Services Development
Problem
The output from the Association Rules data mining model in SQL Server Analysis Services can be difficult to understand in terms of the calculations named Probability and Importance. In this tip we will walk through an example of how to get the Probability and Importance calculations to help you better understand how to use this feature in SSAS.
Solution
In this tip, we show how to create a simple data mining model using the Association Rules algorithm in SQL Server Analysis Services 2012. At the conclusion, T-SQL statements are provided to show how the mining model calculates the probability and importance displayed in the mining model viewer. The solution presented here uses data from a banking example provided by Bamshad Mobasher at DePaul University.
The first step is to create a table and load it with data using the T-SQL sample below.
create table dbo.tblAssociationRulesExample
(
UniqueID integer identity(1,1) Primary Key,
AgeRange varchar(8) not null,
Gender varchar(6) not null,
Region varchar(10) not null,
Income varchar(8) not null,
Married varchar(3) not null,
NumberOfChildren int not null,
IsCarOwner varchar(3) not null,
HasSavingsAccount varchar(3) not null,
HasCurrentAccount varchar(3) not null,
HasMortgage varchar(3) not null,
DidBuyAPersonalEquityPlan varchar(3) not null
)
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Low','NO',1,'NO','NO','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','YES',3,'YES','NO','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Low','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','YES',3,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','High','YES',0,'NO','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','Middle','YES',2,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','RURAL','Low','NO',0,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','TOWN','Middle','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','SUBURBAN','Middle','YES',2,'YES','NO','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','TOWN','Low','YES',2,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','High','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','NO',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Low','YES',1,'NO','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','High','YES',1,'YES','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','Low','YES',0,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Low','YES',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Low','YES',2,'NO','NO','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','SUBURBAN','Middle','YES',0,'NO','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','YES',0,'NO','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Low','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','High','YES',2,'NO','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Low','YES',2,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Middle','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','NO',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','NO',2,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Middle','YES',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Low','YES',0,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Low','YES',1,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Middle','NO',3,'YES','NO','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','RURAL','Low','YES',1,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','Low','YES',2,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','YES',2,'NO','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','SUBURBAN','Low','YES',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Middle','NO',3,'YES','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','SUBURBAN','Middle','NO',0,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',2,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','RURAL','Low','YES',3,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','RURAL','Low','NO',0,'YES','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Low','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','SUBURBAN','Middle','NO',2,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','TOWN','Middle','YES',0,'NO','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Middle','YES',0,'YES','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','TOWN','High','NO',2,'YES','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Middle','YES',0,'YES','NO','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','NO',2,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','High','YES',2,'NO','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Low','NO',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','NO',2,'NO','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Middle','NO',2,'YES','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','RURAL','Low','YES',2,'YES','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Low','NO',2,'YES','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Low','YES',0,'NO','NO','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Low','YES',1,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','SUBURBAN','Middle','NO',1,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','TOWN','High','YES',0,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','High','NO',3,'NO','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','NO',0,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',0,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',0,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Middle','NO',1,'YES','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Middle','YES',1,'NO','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','NO',1,'YES','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Middle','YES',2,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',0,'NO','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Low','NO',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Low','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Low','NO',2,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Middle','NO',0,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Low','NO',2,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','RURAL','Low','YES',2,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',3,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','NO',0,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Middle','YES',3,'YES','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Low','YES',2,'NO','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','High','NO',2,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','Middle','NO',2,'YES','NO','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Middle','NO',0,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','High','YES',1,'YES','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',0,'YES','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','Middle','YES',2,'YES','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Low','NO',3,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Middle','NO',3,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',1,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Low','YES',1,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Low','YES',0,'NO','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Middle','YES',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','Low','NO',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','SUBURBAN','Low','YES',0,'YES','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','YES',2,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','YES',1,'YES','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Middle','NO',2,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','Middle','NO',0,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Middle','YES',2,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','YES',0,'YES','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',1,'NO','NO','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Middle','YES',2,'YES','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Low','NO',2,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','RURAL','Low','YES',0,'YES','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Middle','YES',1,'NO','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',2,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Low','YES',0,'YES','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','NO',0,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','YES',1,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','YES',3,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','High','YES',0,'YES','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',0,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','NO',0,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',2,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','NO',2,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Middle','YES',3,'YES','NO','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','YES',0,'YES','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','NO',2,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Middle','YES',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','High','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','Low','YES',2,'NO','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',3,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Low','NO',0,'YES','NO','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','High','YES',3,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','Middle','NO',2,'NO','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','High','YES',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Low','YES',1,'NO','YES','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','RURAL','Middle','NO',1,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','High','NO',3,'YES','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Middle','YES',2,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Middle','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Middle','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Low','YES',3,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','RURAL','Low','NO',0,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Low','NO',2,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','RURAL','Middle','YES',3,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','SUBURBAN','Low','NO',2,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','SUBURBAN','Middle','YES',0,'YES','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','High','YES',2,'YES','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','Middle','YES',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',2,'YES','NO','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','NO',0,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','Middle','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','High','NO',1,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Middle','YES',3,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Low','YES',0,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','YES',1,'YES','NO','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','TOWN','High','YES',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',1,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','SUBURBAN','High','YES',0,'NO','YES','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Low','YES',2,'YES','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','NO',2,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','RURAL','Middle','YES',0,'YES','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','SUBURBAN','Middle','YES',3,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','RURAL','Middle','YES',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','NO',2,'YES','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','TOWN','High','YES',2,'NO','YES','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Middle','YES',1,'NO','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','Low','NO',2,'YES','NO','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','SUBURBAN','Low','YES',2,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','RURAL','Low','YES',2,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','Low','YES',0,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Low','YES',1,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',2,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Low','YES',0,'NO','NO','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Low','NO',3,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','NO',1,'YES','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Middle','YES',0,'NO','NO','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','RURAL','Low','YES',1,'NO','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Low','NO',1,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','NO',1,'NO','NO','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Middle','NO',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Middle','YES',0,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','High','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',2,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Low','YES',3,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','RURAL','Middle','YES',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','Middle','YES',2,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','High','NO',0,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Middle','YES',0,'YES','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Low','YES',0,'NO','NO','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Middle','YES',2,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',1,'NO','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','RURAL','High','NO',0,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','NO',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Low','YES',2,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Middle','NO',0,'YES','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','Middle','YES',1,'YES','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',0,'NO','NO','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Middle','YES',1,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Middle','YES',2,'YES','NO','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Low','YES',0,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','SUBURBAN','High','YES',2,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Low','YES',1,'YES','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','High','YES',3,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Low','YES',0,'YES','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','SUBURBAN','Middle','YES',2,'YES','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Low','YES',1,'NO','YES','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','NO',0,'NO','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','High','YES',2,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','NO',2,'NO','NO','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',0,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','YES',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Middle','YES',0,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Low','YES',0,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Low','NO',3,'YES','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',1,'NO','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','NO',0,'YES','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','High','NO',0,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',0,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Middle','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','NO',0,'NO','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Middle','NO',0,'YES','NO','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','TOWN','Middle','YES',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',0,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Low','NO',1,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','SUBURBAN','Low','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','SUBURBAN','Low','YES',0,'YES','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Middle','YES',3,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','NO',0,'YES','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Middle','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Middle','NO',2,'YES','NO','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Middle','YES',2,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Middle','YES',1,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','YES',0,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','RURAL','High','YES',3,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','RURAL','Middle','NO',0,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','High','YES',2,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','TOWN','Middle','NO',0,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','Middle','NO',0,'YES','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','NO',0,'YES','NO','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','YES',0,'YES','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Middle','NO',1,'NO','NO','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','SUBURBAN','Low','YES',0,'NO','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Middle','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','Middle','NO',3,'NO','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Low','NO',1,'NO','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','TOWN','High','NO',2,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',2,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','RURAL','Low','YES',2,'NO','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','RURAL','Low','YES',2,'YES','NO','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','High','NO',0,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Middle','YES',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','Middle','YES',2,'YES','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','SUBURBAN','Middle','NO',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','NO',3,'YES','NO','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','RURAL','Low','YES',0,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Low','YES',3,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Low','YES',3,'YES','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','High','NO',0,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Middle','YES',1,'YES','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',2,'NO','NO','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Low','YES',1,'NO','NO','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','RURAL','Low','NO',3,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Low','NO',0,'YES','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','SUBURBAN','Middle','NO',2,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','YES',2,'NO','NO','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Low','NO',3,'NO','NO','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Low','NO',0,'NO','NO','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','SUBURBAN','Low','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Middle','YES',1,'NO','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Low','YES',0,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','High','YES',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','NO',0,'YES','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',1,'YES','NO','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','TOWN','Middle','NO',0,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','SUBURBAN','Middle','NO',0,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','Middle','YES',0,'YES','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Low','NO',3,'YES','NO','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','SUBURBAN','High','NO',2,'NO','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','High','NO',0,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Low','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Middle','YES',1,'YES','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Middle','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','RURAL','Low','YES',0,'YES','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','SUBURBAN','Middle','NO',1,'NO','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Low','YES',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','Middle','NO',0,'NO','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','YES',1,'NO','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',1,'NO','NO','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','High','YES',1,'YES','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Middle','YES',3,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',3,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Low','YES',0,'NO','NO','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Middle','YES',1,'YES','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','YES',3,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',1,'NO','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','Middle','YES',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','NO',0,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Middle','NO',0,'YES','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','RURAL','High','YES',2,'YES','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Low','YES',0,'NO','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Middle','YES',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','Middle','NO',2,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','RURAL','Low','YES',2,'NO','NO','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Low','NO',2,'YES','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',1,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Low','YES',0,'NO','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Middle','YES',0,'NO','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','Middle','YES',3,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','High','NO',3,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','RURAL','Low','YES',0,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','High','NO',2,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','Middle','NO',0,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','NO',2,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','NO',1,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Middle','NO',1,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','Middle','NO',2,'YES','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','RURAL','Low','NO',2,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','Low','YES',0,'YES','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','Middle','NO',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Low','NO',2,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Middle','NO',1,'NO','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','NO',2,'NO','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','SUBURBAN','Low','NO',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Middle','NO',2,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','Low','YES',0,'YES','NO','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','YES',1,'YES','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Low','NO',0,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','SUBURBAN','Middle','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','NO',0,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Middle','YES',1,'NO','YES','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',0,'NO','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','High','NO',1,'NO','YES','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','YES',3,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','High','YES',3,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',2,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Middle','YES',0,'NO','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','SUBURBAN','Low','YES',2,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','SUBURBAN','Low','YES',1,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','YES',1,'NO','YES','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Middle','YES',2,'NO','NO','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Middle','YES',1,'YES','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','SUBURBAN','Middle','YES',2,'YES','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',0,'NO','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','SUBURBAN','Middle','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','RURAL','High','YES',1,'YES','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','High','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Low','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','RURAL','Low','YES',2,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','Middle','YES',1,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','Middle','YES',0,'YES','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','High','YES',0,'NO','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Middle','YES',0,'NO','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Low','NO',1,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Middle','NO',0,'YES','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','YES',0,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','Middle','NO',1,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','NO',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','SUBURBAN','Middle','YES',0,'YES','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','High','YES',2,'NO','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','SUBURBAN','Low','YES',0,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','RURAL','Low','NO',0,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','NO',3,'YES','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Low','YES',1,'YES','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','High','NO',2,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','TOWN','Low','YES',3,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','TOWN','Middle','YES',2,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','High','YES',1,'YES','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',2,'YES','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','NO',1,'YES','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','High','YES',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Low','YES',0,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Middle','YES',3,'NO','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','High','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Middle','NO',2,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','NO',0,'NO','NO','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','YES',0,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','SUBURBAN','High','YES',2,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Low','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','Middle','NO',1,'NO','NO','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Middle','NO',2,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','SUBURBAN','Low','YES',0,'NO','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',3,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','Middle','NO',0,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Middle','YES',2,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',1,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Middle','YES',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Middle','YES',0,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','NO',3,'YES','NO','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Low','NO',0,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Middle','NO',1,'YES','NO','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','NO',0,'YES','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Low','YES',0,'NO','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','High','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Low','NO',0,'YES','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','Middle','YES',3,'YES','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Low','YES',2,'YES','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','SUBURBAN','Middle','NO',0,'YES','NO','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','Low','YES',3,'YES','NO','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','Middle','YES',0,'YES','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Middle','YES',2,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','High','NO',1,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','YES',0,'YES','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','RURAL','Low','NO',0,'NO','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','RURAL','Low','NO',3,'YES','NO','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Middle','YES',0,'YES','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Low','NO',0,'NO','NO','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',3,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','SUBURBAN','Middle','YES',3,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','SUBURBAN','High','NO',1,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','SUBURBAN','Low','NO',0,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','SUBURBAN','Low','YES',1,'YES','NO','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','SUBURBAN','Low','YES',2,'NO','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','NO',1,'YES','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','NO',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','High','NO',2,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',0,'YES','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','SUBURBAN','High','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','RURAL','Low','YES',0,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Low','NO',1,'NO','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','RURAL','Low','YES',1,'YES','NO','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Middle','YES',2,'YES','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','TOWN','Low','YES',0,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','High','YES',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Middle','NO',1,'NO','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',1,'YES','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','High','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Low','NO',1,'YES','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','RURAL','Middle','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','Middle','YES',3,'NO','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','YES',2,'YES','NO','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',1,'YES','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','Middle','NO',2,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','YES',0,'NO','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','High','YES',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Low','NO',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','RURAL','Middle','YES',0,'NO','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Low','YES',0,'YES','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Low','NO',2,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Low','YES',0,'YES','NO','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','NO',1,'YES','YES','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','SUBURBAN','Low','YES',1,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',1,'YES','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Middle','YES',1,'NO','YES','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','High','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','RURAL','Middle','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','NO',0,'YES','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','RURAL','Low','YES',0,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','Middle','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','Middle','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Middle','YES',2,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','RURAL','High','YES',3,'YES','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','RURAL','Middle','NO',0,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Middle','YES',3,'YES','NO','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','NO',0,'YES','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','NO',0,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','High','NO',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','NO',0,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','YES',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','High','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','SUBURBAN','Low','NO',1,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','TOWN','High','YES',1,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Low','YES',0,'YES','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','SUBURBAN','Middle','YES',0,'YES','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',0,'YES','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','RURAL','Low','YES',2,'YES','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Low','NO',0,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','Middle','YES',2,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Low','YES',0,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','SUBURBAN','Low','NO',3,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','SUBURBAN','Low','YES',0,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','TOWN','Middle','NO',3,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','YES',0,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Low','YES',2,'YES','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Middle','NO',0,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','NO',1,'YES','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','YES',2,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','Middle','NO',1,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Middle','YES',0,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Low','YES',2,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','NO',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','RURAL','Low','YES',2,'NO','NO','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','High','NO',2,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','Middle','NO',0,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','RURAL','Low','YES',0,'YES','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','High','YES',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Low','YES',0,'NO','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','RURAL','Low','YES',1,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','YES',3,'NO','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',2,'NO','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','YES',1,'YES','YES','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Low','NO',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','Middle','YES',0,'YES','YES','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Middle','NO',0,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','RURAL','Middle','YES',3,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Middle','YES',0,'NO','NO','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','NO',2,'YES','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','High','NO',0,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','High','NO',0,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Low','YES',0,'YES','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Middle','YES',3,'YES','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','NO',1,'YES','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Middle','YES',0,'YES','NO','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','NO',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','High','YES',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Middle','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Low','YES',0,'NO','NO','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','SUBURBAN','Low','NO',0,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','SUBURBAN','High','NO',2,'NO','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','RURAL','Low','YES',2,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','YES',0,'NO','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Low','YES',3,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','High','YES',0,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','RURAL','Low','NO',3,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Middle','NO',0,'YES','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Low','YES',1,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Low','NO',0,'NO','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','TOWN','Middle','YES',1,'NO','YES','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','NO',3,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','YES',3,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Low','YES',2,'YES','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Low','YES',2,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','SUBURBAN','Low','NO',3,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','YES',0,'YES','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','SUBURBAN','Low','YES',0,'YES','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Low','YES',1,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','NO',2,'NO','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','NO',1,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Middle','YES',2,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','RURAL','Middle','YES',1,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','SUBURBAN','High','YES',1,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Middle','NO',1,'YES','NO','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Middle','NO',1,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','INNER_CITY','Middle','YES',0,'YES','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','NO',1,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',0,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','NO',1,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','High','NO',2,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Middle','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',0,'NO','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Low','YES',1,'YES','YES','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','Middle','YES',2,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',2,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','SUBURBAN','High','YES',1,'YES','YES','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','Low','YES',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Middle','NO',0,'NO','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','NO',0,'YES','NO','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','SUBURBAN','Low','YES',2,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','Low','YES',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','TOWN','High','YES',1,'YES','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',1,'YES','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','SUBURBAN','Middle','YES',3,'NO','NO','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Middle','YES',2,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','SUBURBAN','Middle','YES',0,'YES','NO','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','Middle','YES',3,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','YES',2,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','RURAL','Low','YES',1,'YES','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','RURAL','Middle','YES',0,'NO','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','SUBURBAN','Middle','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','SUBURBAN','Middle','YES',0,'NO','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Low','NO',1,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','SUBURBAN','Low','NO',0,'NO','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','High','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','NO',1,'NO','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','SUBURBAN','Low','YES',0,'YES','NO','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Middle','YES',0,'YES','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Low','YES',0,'NO','NO','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',2,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Middle','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Low','NO',1,'YES','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','RURAL','Middle','NO',3,'YES','NO','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','INNER_CITY','Middle','YES',0,'NO','NO','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','SUBURBAN','Middle','NO',2,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Low','YES',2,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Middle','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','YES',0,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','YES',1,'YES','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','TOWN','High','YES',0,'YES','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','NO',0,'NO','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Middle','YES',0,'YES','NO','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','SUBURBAN','High','YES',2,'YES','YES','NO','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Low','YES',2,'YES','NO','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Low','NO',3,'NO','YES','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','RURAL','Middle','NO',2,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Low','YES',1,'NO','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','TOWN','Low','NO',3,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',1,'NO','NO','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','TOWN','Middle','NO',1,'YES','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','RURAL','High','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','SUBURBAN','Low','YES',1,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',0,'NO','NO','NO','NO','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','FEMALE','INNER_CITY','Middle','NO',2,'NO','YES','YES','YES','YES')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Low','YES',0,'NO','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','MALE','SUBURBAN','High','YES',2,'NO','YES','YES','NO','YES')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','RURAL','Middle','YES',3,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('51-100','FEMALE','INNER_CITY','High','NO',2,'YES','YES','YES','YES','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','INNER_CITY','Low','YES',0,'YES','YES','YES','NO','NO')
insert into dbo.tblAssociationRulesExample values ('0-34','FEMALE','TOWN','Low','YES',0,'YES','YES','NO','NO','YES')
insert into dbo.tblAssociationRulesExample values ('0-34','MALE','INNER_CITY','Low','YES',0,'NO','YES','NO','YES','NO')
insert into dbo.tblAssociationRulesExample values ('35-50','MALE','TOWN','Middle','NO',0,'YES','NO','YES','YES','YES')
The first five rows of data is shown below. This data will be used as the input for the data mining algorithm.
In Visual Studio (also known from the start menu as SQL Server Data Tools), create a new Analysis Services Multidimensional and Data Mining Project. In this tip, we will name the project Association Rules Example. Click on OK when finished with the New Project window.
In the Solution Explorer window, right-click on the Data Sources folder and choose "New Data Source..." to initiate the Data Source Wizard. Click on "Next".
Choose your data connection, if one exists. If a Data connection does not exist, click on "New..." to create a new data connection. In this example, we are using a connection to the Tips database on the localhost. Click on "Next".
On the Impersonation Information screen, click on "Use a specific Windows user name and password." Enter your username and password. Click on "Next".
On the Completing the Wizard screen, the data source name can be changed if desired. Click on "Finish".
In the Solution Explorer window, right-click on the Data Source Views folder and choose "New Data Source View..." to launch the Data Source View Wizard. Click on "Next".
On the Select a Data Source page in the Relational data sources window, select the data source we created in the above step. Click on "Next".
On the Select Tables and Views page, move tblAssociationRulesExample from the Available Objects box to the Included object box by selecting tblAssociationRulesExample in the Available objects box and then clicking on the ">" box. Click on "Next".
On the Completing the Wizard page, give the Data Source View a name and click on "Finish". On the Name Matching page, check the box for "Create logical relationships by matching columns." In the Foreign key matches box, press the "Same name as primary key" button. Click on "Next".
The Solution Explorer should appear as it does below with one Data Source and one Data Source View defined.
In the Solution Explorer window, right-click on the Mining Structures folder and choose "New Mining Structure..." to launch the Data Mining Wizard. Click on "Next".
On the Select the Definition Method page, press the radio button labeled "From existing relational database or data warehouse". Click on "Next".
On the Create the Data Mining Structure page, press the radio button labeled "Create mining structure with a mining model". Choose the "Microsoft Association Rules" data mining technique from the drop-down box.
On the Select Data Source View page, choose "Tips" from the Available data source views. Please note this is the data source view we created earlier. Click on "Next".
On the Specify Table Types page, make sure the Case box is checked and the Nested box is unchecked for the table named tblAssociationRulesExample. Click on "Next".
On the Specify the Training Data page, ensure that the check box is checked in the Key column for the UniqueID - this should happen by default. Also, in the Predictable column, check the check box for the DidBuyAPersonalEquityPlan attribute. The remainder of the columns should have the check box checked in the Input column. When finished the page should appear as shown below. Click on "Next".
On the Specify Columns' Content and Data Type page, we see the columns to be used in the mining model structure, along with their content and data types. Click on "Next".
On the Create Testing Set page, we will set the "Percentage of data for testing" and "Maximum number of cases in testing data set" to zero for this example. Please note that there needs to be a set of data reserved for testing or use 10-fold cross validation to prevent overfitting the data mining model to the training data. Click on "Next".
On the Completing the Wizard page, the name of the mining structure and model can be changed. Click on "Finish".
The Solution Explorer window should appear as shown below.
Before continuing, examine the Visual Studio project's properties page to ensure that the deployment location is a server that has Analysis Services running and that you have permission to create and process Analysis Services objects on the server.
In Visual Studio, the Mining Structure tab of the data mining model should appear as shown below. Notice there are five tabs on the page, Mining Structure, Mining Models, Mining Model Viewer, Mining Accuracy Chart and Mining Model Prediction.
Click on the Mining Model Viewer tab. A message box should appear asking if you would "like to build and deploy the project first". Click on Yes.
The Deployment Progress window will appear and a message should display stating that the "mining model must be processed before you can browse its content." The box also gives a warning that "it could take some time to process the mining model depending on the amount of data." Since we only have 600 records in this example, the processing should only take a few seconds. When asked if "you wish to continue", click on "Yes".
Next the Process Mining Model window should appear. We will leave all of the settings at their default values. Click on "Run..."
The Process Progress window will appear detailing the processing that is occurring on the server. When the process has succeeded, click on "Close" to return to the Process Mining Model window. Click on "Close" in the Process Mining Model window to return to Visual Studio. You might see a window asking you to wait while the model is loading.
The Mining Model Viewer tab should now appear as shown below. The rules can be sorted by Probability, Importance and the Rule.
While the mathematics to explain the probability and importance values with complex rules can get complicated, I will explain these calculations using the simple rule that Region = SUBURBAN implies that Did Buy A Personal Equity Plan = YES.
The T-SQL below shows how the Probability is calculated.
declare @SuburbanYesCount float
declare @SuburbanCount float
--Get the total count for the rule Region='SUBURBAN' implies DidBuyAPersonalEquityPlan='YES'
set @SuburbanYesCount=(select cast(count(*) as float) from dbo.tblAssociationRulesExample
where Region='SUBURBAN' and DidBuyAPersonalEquityPlan='YES')
--Get the total count for all Region='SUBURBAN'
set @SuburbanCount=(select cast(count(*) as float) from dbo.tblAssociationRulesExample
where Region='SUBURBAN')
select @SuburbanYesCount as CountOfSuburbanAndYes,
@SuburbanCount as CountOfAllSuburban,
round(@SuburbanYesCount/@SuburbanCount,3) as Probability
The T-SQL below shows how the Importance is calculated.
declare @SuburbanYesCount float
declare @NotSuburbanNoCount float
declare @SuburbanNoCount float
declare @NotSuburbanYesCount float
declare @Numerator float
declare @Denominator float
-- The algorithm adds one to each count to prevent divide by zero errors
set @SuburbanYesCount=(select cast(count(*)+1 as float) from dbo.tblAssociationRulesExample
where Region='SUBURBAN' and DidBuyAPersonalEquityPlan='YES')
set @NotSuburbanNoCount=(select cast(count(*)+1 as float) from dbo.tblAssociationRulesExample
where Region<>'SUBURBAN' and DidBuyAPersonalEquityPlan='NO')
set @SuburbanNoCount=(select cast(count(*)+1 as float) from dbo.tblAssociationRulesExample
where Region='SUBURBAN' and DidBuyAPersonalEquityPlan='NO')
set @NotSuburbanYesCount=(select cast(count(*)+1 as float) from dbo.tblAssociationRulesExample
where Region<>'SUBURBAN' and DidBuyAPersonalEquityPlan='YES')
--echo the values
select @SuburbanYesCount as SuburbanYesCount,
@NotSuburbanNoCount as NotSuburbanNoCount,
@SuburbanNoCount as SuburbanNoCount,
@NotSuburbanYesCount as NotSuburbanYesCount
set @Numerator=(select @SuburbanYesCount/(@SuburbanYesCount+@SuburbanNoCount))
set @Denominator=(select @NotSuburbanYesCount/(@NotSuburbanYesCount+@NotSuburbanNoCount))
select @Numerator as Numerator,
@Denominator as Denominator,
@Numerator/@Denominator as Quotient
select round(LOG10(@Numerator/@Denominator),3) as Importance
Next Steps
Explore the different association rules to discover interesting patterns in the data and read the following tips to find out more about data mining functionality in SQL Server 2012 Analysis Services.
About the author
Dr. Dallas Snider is an Assistant Professor in the Computer Science Department at the University of West Florida and has 18+ years of SQL experience.This author pledges the content of this article is based on professional experience and not AI generated.
View all my tips
Article Last Updated: 2014-03-07
