Apriori algorithm-find all frequent large itemsets, Database Management System

Your friend owns a computer store in Yuen Long, selling Desktop and Notebook PCs and other computer peripherals. Having been rather successful with his business there, he decided to venture into the infamous Mongkok Computer Center and has already been there for three months. As expected, compared to his Yuen Long store, his new store has been recording much larger revenue but when it comes to profit, he is not so sure. He needs to pay several times more in rent! In order to stimulate sales, your friend feels that he needs to understand his customers in Mongkok more. To help him do so, you have asked for a sample of the transactional data he collected and they are shown in Table.

a)  Set the Minimum Support to 18% and Minimum Confidence to 80%, find all frequent large itemsets (for product items) and all interesting rules using the Apriori algorithm.

(Please show your work step by step clearly and discuss what you would do with the item "Maintenance".)

b) By setting the Lift Ratio to 2, which rules you discovered in Part (a) are still interesting?

c) How many possible association rules (even though both the support and confidence are 0) would be generated from the following itemsets: {Case, Desktop, Maintenance, Mouse, Speaker, Webcam} and {Computer, Printer, Peripherals, Notebook_PC}. Compare the results, what you can conclude?

 

 

Posted Date: 4/5/2013 5:19:31 AM | Location : United States







Related Discussions:- Apriori algorithm-find all frequent large itemsets, Assignment Help, Ask Question on Apriori algorithm-find all frequent large itemsets, Get Answer, Expert's Help, Apriori algorithm-find all frequent large itemsets Discussions

Write discussion on Apriori algorithm-find all frequent large itemsets
Your posts are moderated
Related Questions
Describe the Association: Design  Before we describe association design let us define association "Association is set of links between two objects in the object model". It is

create an e-r diagram usuing graphical dipicted software that could theoritically be used in resturant application

MOSS VALE is a town with 15000 inhabitants. The fire department wishes to develop a system that automates the despatch of fire engines to attend fires. The ERD below describes the

Data Redundancy -A lot of information is being repeated in the relation. For instance, the information that MCS-014 is named SSAD is repetitive, address of Rahul is "D- 27, Main ro

The Second Normal Form (2NF) Definition: A relation is in 2NF if it is in 1NF and each non-key attribute is fully dependent on each candidate key of the relation. Some of th

In which form of relational database developer refers to a record? In a tuple form of relational database developer refers to a record.

Describe the GRANT function and explain, how it associates to security. What kind of privileges may be granted? How are they revoked? Ans: Since more than one user can aacce

Explain degree of relation? Degree of a Relation - The degree or arity of a relation is the number of attributes n of its relation schema.

) Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a picto

What is Message switching Message switching transmits data units which can be arbitrarily long. Packet switching has a utmost packet size, if any message longer than that, it s