Find all of the strong association rules

Assignment Help Database Management System
Reference no: EM13517720

All answers must be computer generated (including text and diagrams).

The hand-in version must include a header page (or with sufficient space) indicating: student name, course number and assignment number.

Question 1 : The transactions are presented in the table. Let min sup =3 and min conf = 80%.

TID items bought
T1 I1,I1,I2,I3,I4, I5, I6
T2 I7, I2, I3, I4, I5, I6
T3 I1, I8, I4, I5
T4 I1, I9, I10, I4, I6
T5 I10, I2, I2, I4, I 5

(a) Use an Apriori algorithm to find all frequent itemsets.

(b) Use an FP-growth algorithm to find all frequent itemsets.

(c) Find all of the strong association rules. Provide support, c onfidence, and lift for all the rule. Provide the reasons why the rules you selected are interesting.

Reference no: EM13517720

Questions Cloud

Define component were acetaminophen rather than acetanilide : Although acetanilide and phenacetin aren't appreciably acidic, acetaminophen(like aspirin) is a stronger acid than water.what problem would you encounter if the unknown component were acetaminophen rather than acetanilide or phenacetin, and you ex..
Find the maximum radius of a million-solar-mass black hole : There is strong evidence that the center of the Milky Way galaxy contains a giant black hole with a mass of perhaps one million Suns. find the maximum radius of a million-solar-mass black hole
Compute the partial pressure of hydrogen gas : Use Dalton's law and the vapor pressure of water at 22C to compute the partial pressure of hydrogen gas in the collecting tube.
Compute the potential at the center of sphere : A charged conducting sphere has a radius of 10.0 cm and is surrounded by an electric field. What is the potential at the center of sphere
Find all of the strong association rules : Find all of the strong association rules. Provide support, c onfidence, and lift for all the rule. Provide the reasons why the rules you selected are interesting.
Explain treatment of cardiac arrest victims : Emergency treatment of cardiac arrest victims sometimes involves injection of a calcium chloride solution directly into the heart muscle
What is the energy loss rate of the cube : A cube of side of length 0.55 m has a temperature of 310 K and is in a room surrounded by 15.8ºC walls. what is the energy loss rate of the cube
Calculate the temperature of the filament when it is hot : A certain lightbulb has a tungsten filament having a resistance of 16 ? at 22°C and 155 ? when hot. Find the temperature of the filament when it is hot
What is the heat flow rate through the composite rod : A 5.4 m-long rod of (constant diameter 4.6 mm) is made of 2.0 m of copper and the remainder of aluminum (see above). What is the heat flow rate through the composite rod

Reviews

Write a Review

Database Management System Questions & Answers

  Design updateable database for storing customer and sales

Design an updateable database for storing customer and sales data. Explain how to deal with the problems of missing data.

  Describe the challenges that an organization will face when

describe the challenges that an organization will face when changing business processes and how information systems

  Brief synopsis analyzing the detailed requirements

Provide a brief synopsis analyzing the detailed requirements of your prototype database design and design a database prototype that includes diagrams, data dictionary, design decisions, limitations, etc.

  Essay on data mining in warehouse architectures

Course: data mining. Require a 7 page essay on subjects: Warehouse Architectures: the paper requires to contain information about centralized, federated, and tiered data warehouse.

  Describing the purpose of database an its functionality

Describing the purpose of database an its functionality, plus a detailed E-R diagram.

  Explain denormalized table in normal form

The DBA denormalized some of the data in the Premiere Products database to improve performance. Which field or fields cause the table to no longer be in third normal form? In which normal form is the denormalized table?

  Prove-leaves of binary search tree are located in bottom

Examples for small n are given bellow, where a small square box represents an unsuccessful search. Prove that leaves of any binary search tree are located in the bottom two levels.

  Physical design and implementation it requires the use of a

physical design and implementation it requires the use of a relational database management system. strayer university

  Coastal seafoodcoastal seafood is a family-owned business

coastal seafoodcoastal seafood is a family-owned business that operates on the east coast. the company already uses

  Write a program to sort back into a single file

Write a program to sort these back into a single file. Oh, and we only have a few nanoseconds to do it, so you'd better do it with pthreads!

  Execution of the SQL commands - Create Tables using SQL DDL

The appropriate SQL command which should be copied from your source code in MySQL and resultant tables, which must be screenshots to show the change due to the execution of the SQL commands

  Evaluate the selection of a database management

Identify and describe three criteria that should be used to evaluate the selection of a database management system. Describe how an organization should use each criterion to evaluate database management system selection.

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