2) A database has four transactions. Let min sup = 60% and min.conf = 80%. %3D TID items_bought (in the form of brand-item.category) {King's-Crab, Sunset-Milk, Dairyland-Cheese, Best-Bread} {Best-Cheese, Dairyland-Milk, Goldenfarm-Apple, Tasty-Pie, Wonder-Bread} {Westcoast-Apple, Dairyland-Milk, Wonder-Bread, Tasty-Pie} {Wonder-Bread, Sunset-Milk, Dairyland-Cheese} cust ID 01 T100 02 T200 01 Т300 03 T400 (a) At the granularity of item_category (e.g., item; could be "Milk"), for the following rule template, VX € transaction, buys(X, item1) A buys(X, item2) = buys(X, item3) [s, c] list the frequent k-itemset for the largest k, and all of the strong association rules (with their support s and confidence c) containing the frequent k-itemset for the largest k. (b) At the granularity of brand-item.category (e.g., item; could be "Sunset-Milk"), for the following rule template, VX € customer, buys(X, item1) A buys(X, item2) = buys(X, item3) list the frequent k-itemset for the largest k (but do not print any rules).

A Guide to SQL
9th Edition
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Philip J. Pratt
Chapter2: Database Design Fundamentals
Section: Chapter Questions
Problem 11RQ
icon
Related questions
Question
i need the answer quickly
2)
A database has four transactions. Let min sup = 60% and min.conf
= 80%.
%3D
TID
items_bought (in the form of brand-item.category)
{King's-Crab, Sunset-Milk, Dairyland-Cheese, Best-Bread}
{Best-Cheese, Dairyland-Milk, Goldenfarm-Apple, Tasty-Pie, Wonder-Bread}
{Westcoast-Apple, Dairyland-Milk, Wonder-Bread, Tasty-Pie}
{Wonder-Bread, Sunset-Milk, Dairyland-Cheese}
cust ID
01
T100
02
T200
01
T300
03
T400
(a) At the granularity of item_category (e.g., item; could be "Milk"), for the following rule template,
VX € transaction, buys(X, item1) A buys(X, item2) = buys(X, item3) [s, c]
list the frequent k-itemset for the largest k, and all of the strong association rules (with their
support s and confidence c) containing the frequent k-itemset for the largest k.
(b) At the granularity of brand-item.category (e.g., item; could be "Sunset-Milk"), for the following
rule template,
VX € customer, buys(X, item1) A buys(X, item2) = buys(X, item3)
list the frequent k-itemset for the largest k (but do not print any rules).
Transcribed Image Text:2) A database has four transactions. Let min sup = 60% and min.conf = 80%. %3D TID items_bought (in the form of brand-item.category) {King's-Crab, Sunset-Milk, Dairyland-Cheese, Best-Bread} {Best-Cheese, Dairyland-Milk, Goldenfarm-Apple, Tasty-Pie, Wonder-Bread} {Westcoast-Apple, Dairyland-Milk, Wonder-Bread, Tasty-Pie} {Wonder-Bread, Sunset-Milk, Dairyland-Cheese} cust ID 01 T100 02 T200 01 T300 03 T400 (a) At the granularity of item_category (e.g., item; could be "Milk"), for the following rule template, VX € transaction, buys(X, item1) A buys(X, item2) = buys(X, item3) [s, c] list the frequent k-itemset for the largest k, and all of the strong association rules (with their support s and confidence c) containing the frequent k-itemset for the largest k. (b) At the granularity of brand-item.category (e.g., item; could be "Sunset-Milk"), for the following rule template, VX € customer, buys(X, item1) A buys(X, item2) = buys(X, item3) list the frequent k-itemset for the largest k (but do not print any rules).
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 4 images

Blurred answer
Knowledge Booster
Fundamentals of Datawarehouse
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr