matthew danella 912793069

Support- the frequency of occurrence in an item set. It is also a fraction of transactions that contain all item sets in the relationship. The variables can be calculated separately.

Confidence- explains the […]

Spotcrime is an example of OLAP because it uses dimensions such as time, address, and zip code to analyze the crime data. You can view locations of where the crime occured, and see what happened during the crime, […]

The Chi-squared test helps to make sure that the outcome class is not the same in each node. The Gini index gives us an idea of how the outcomes relate to each other. After going through the Chi-squared test, Gini […]

i like extra points…

Clustering is a process of grouping multiple pieces of data that has similar or relevant attributes or characteristics into a single group. For example, creating groups of similar customers.Classification is using […]

2. Data mining consists of looking through a large amount of data in order to find patterns that tell you things such as how areas of the company are related, why something happened and help predict what will […]

2. Candidates can pull past information about who people voted for in certain states or sections of the country, and what percentage of a state voted republican or democrat. This information can be used by the […]

1. Choosing the business process- defines what data warehouse should be used and what should be covered in the data warehouse model.
2. Deciding on level of granularity- describes what the data cube should be […]

DELETE is a Data Manipulation Language(DML) command to take out a field or entry of data from a table DELETE m72moviedb.actor WHERE firstname=Matt. DROP is a Data Definition Language(DDL) command where an entire […]

SQL can be dividedinto two seperate parts: DML and DDL. Data Manipulation Language (DML) is formed up of query and update commands such as Select, Update, Delete, and Insert Info. The Data Definition Language […]

To retrieve values from the SQL Database one would use the SELECT command to retrieve on column of data. To receive all columns of data, one would use the SELECT * command.

In order to resolve a many to many relationship while creating a database, one must create a new table that relates the information from the many to many tables without having repeating, redundant data. For […]

When people, such as a future employer or boss, give us a project to complete, they usually have specific ideas in mind and criteria that your work should meet. If you neglect finding out these requirements, there […]

The information architecture for a business uses both the transactional data and analytical data to establish decision making principles and standards for how a business should use their data to their advantage. […]