Find the support for itemsets by treating each transaction

Assignment Help Database Management System
Reference no: EM13781874

Write the answer under each question.

Questions:

1- Consider the data in the following table:

CID

TID

Items Bought

10

100

{Milk, Butter, Diapers}

10

115

{Milk, Eggs, Coke, Diapers}

20

85

{Milk, Eggs, Butter, Diapers}

20

125

{Milk, Coke, Butter, Diapers}

30

90

{Eggs, Coke, Diapers}

30

130

{Eggs, Butter, Diapers}

40

155

{Coke, Butter}

40

160

{Milk, Eggs, Coke}

50

60

{Milk, Butter, Diapers}

50

75

{Milk, Eggs, Diapers}

a) Find the support for itemsets {Diapers}, {Eggs, Butter}, and {Eggs, Butter, Diapers} by treating each transaction (TID) as a market basket.

b) Based on the results you got in part (a), Find the confidence for the association rules {Eggs, Butter}à{Diapers} and {Diapers}à{Eggs, Butter}. Is confidence a symmetric measure?

c) Find the support for itemsets {Diapers}, {Eggs, Butter}, and {Eggs, Butter, Diapers} by treating each Customer (CID) as a market basket. Each item should be treated as a binary variable (1 if an item appears in at least one transaction bought by the customer, and 0 otherwise.)

d) Based on the results you got in part (c), Find the confidence for the association rules {Eggs, Butter}à{Diapers} and {Diapers}à{Eggs, Butter}.

2- A database has ten transactions. Let min_sup = 30%.

TID

Items Bought

100

{A, B ,D, E}

200

{B, C, D}

300

{A ,B, D, E}

400

{A, C, D, E}

500

{B, C, D, E}

600

{B, D, E}

700

{C, D}

800

{A, B, C}

900

{A, D, E}

1000

{B, D}

(a) Apply the Apriori algorithm to the above data set.

(b) Show the FP tree that would be made for the data set.

Reference no: EM13781874

Questions Cloud

Does hershey use process manufacturing or assembly process : Does Hershey use process manufacturing or the assembly process? What location factors might go into the selection of a manufacturing site for Hershey's chocolate?
What is socially responsible buying : What is socially responsible buying? What is the psychological contract between an employee and his or her employer? When conducting a social audit, a company should avoid doing all of the following except. Which of the following types of employees m..
How will changes in the quantity supplied : How will changes in the quantity supplied as a result of your pricing decisions affect marginal cost and marginal revenue and besides your pricing decisions, what are your suggested nonpricing strategies? What nonpricing strategies will ..
Opinion on the animal rights perspective : What is your opinion about using animals for research? Was your opinion affected by the readings for this assignment?
Find the support for itemsets by treating each transaction : Find the support for itemsets {Diapers}, {Eggs, Butter}, and {Eggs, Butter, Diapers} by treating each transaction (TID) as a market basket.
Possible legal ramifications of poor business conduct : Which of the following is the best description of the possible legal ramifications of poor business conduct? Which of the following statements is false concerning how a company should communicate after a crisis? Which of the following statements is t..
Hrm only for hifsa shaukat : HRM only for HIFSA shaukat.
Write a three pages paper about the company jordan inc : Write a three pages paper about the company Jordan Inc.
Major drivers issues of health care spending : What are the major drivers of the rise in health care spending? How will the ACA affect these areas?

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd