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

Assignment Help:

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?

 

 


Related Discussions:- Apriori algorithm-find all frequent large itemsets

Explain the togaf framework for enterprise architectures, Question: (a)...

Question: (a) With the help of a diagram, explain the TOGAF framework for enterprise architectures. (b) Where would you position enterprise architectures in an enterpri

What is a name, What is a Name? A user-supplied name is used for identi...

What is a Name? A user-supplied name is used for identity. This form of identity is used for files in file systems. The user gives every file a name that uniquely identifies it

Create an entity relationship diagram, Create an entity relationship diagra...

Create an entity relationship diagram, Database Management System

Dbms, You are managing the following database system: • DBMS: Oracle 11g ...

You are managing the following database system: • DBMS: Oracle 11g • OS: Sun Solaris • System architecture: Web-based application using ASP.Net • Purpose of Server: HR managem

Windows 8 Administrative Tools, Which two tools are used to administer user...

Which two tools are used to administer users for Active Directory?

Designing the database schema , The domain that you will model in this assi...

The domain that you will model in this assignment is that of courses and students at a university. So as not to make the task too large and unspecified, you will here get a descrip

Describe queries with complex types, Describe queries with complex types? ...

Describe queries with complex types? The present extension of the SQL query language deal with the complex type Let us start with the simple example: Find the title and t

Update city of first bank corporation to new delhi, Change the city of Firs...

Change the city of First Bank Corporation to ‘New Delhi' UPDATE COMPANY SET CITY = ‘New Delhi' WHERE COMPANY_NAME = ‘First Bank Corporation';

Explain er relationship model, Explain ER Relationship model? An entity...

Explain ER Relationship model? An entity-relationship model (ERM): An entity-relationship model (ERM) is an abstract theoretical illustration of structured data. Entity-relatio

Write Your Message!

Captcha
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