Question

Details explanation of the 60% calculations and what is the difference between frequent mining constraints and constraints written as the SQL statements?

why monotonic or others cannot be used here

a)   The sum of the prices of all items (in each pattern) is between $100 and $200.

(sumofPricesofallItems>=15 and sumofPricesofallItems<=45) and support is 60%.

b)   The price difference between the most expensive item and the cheapest one in each pattern must be less than or equal to $100.

(costofMostExpensive - costOf Cheapest <=$100) and support is 60%.

Support and confidence are in percentages, which satisfy the above constraint can be retrieved.

c)   The average price of all the items in each pattern is less than $10.

{(ItemsPriced) / (TotalItems) < $10} and support is 60%

Answer 1

a .I ) Select price from items ;

a .2 ) Select items where price <= 45

a .3 ) Select * from items where price > =15 and price <=45

b) SELECT item_price;

FROM_expensive WHERE item_price < = $100

c) SELECT avg FROM all items < $10