Michael Frey

The website SpotCrime.com is an example of OLAP analysis. The crimes are grouped by zip codes and can be broken down into other details like address and the dimensions given on the map. This fits the […]

Classification determines where an entity should belong and it answers a specific question. It is also used to place data within a group. Clustering groups the data the is similar to each other within smaller […]

The chi-squared test is used to provide information of consistency of the child nodes in the decision tree. The outcomes should not be the same. If the p-value is less than .05, then the groups are most likely […]

1. Why is it not a good programming practice to display built-in error messages in the browser?

Built in error messages in the browser could potentially reveal information that you would not like getting in the […]

Summarize what data mining is and what data mining is not.

Data mining is a tool used to gather large quantities of information while predicting potentially useful data that can be used in the future. Data […]

2.What data would be valuable to electoral candidates?

In the previous election, Obama used alot of social media to grab data from potential voters. Social networking sites like Facebook, Twitter, Tumblr, and […]

a) Choosing the business process: The first step in choosing the business process is to analyze your data cube and tell what it is “about.” Then you must ask questions that find out different aspects about the […]

What are some example of functions that help you obtain file and directory information?

File_exists(filename) determines if the directory or file name actually exists. is_readable(filename) determines if the […]

Describe the differences between DELETE and DROP and provide an EXAMPLE.

DELETE is a DML command and DROP is a DDL command. DELETE will not change the physical appearance of the table it is used to removes […]

DML is the data manipulation language. It deals with data manipulation which means it only changes the record, not the physical table itself. There are 4 commands related to the DML which are: select, update, […]

Why would you want to combine strings?

Combining strings, when creating a script saves times for the programmer and also reduces the size of the script itself. When the strings are combined, executing the […]

ERD creates the code for SQL. This is when code is created for the SQL and called forward engineering. When the SQL creates the ERD, it is called reverse engineering.

How do you resolve the M:N (many to many) relationship?

You must seperate the many to many entities to make the relationship a one to many. A new table is created to intersect and connect the entities. The […]

Explain the difference between a while statement and a do…while statement.

The conditions each are tested in are different. In a while, the condition is tested first, and then executed if the condition is […]

The primary key uniquely identify’s an entity. These entity’s need to be uniquely identified by the primary key, so when they are searched within a database, they can be easily found. An example of this when it […]

Transactional data is the data that is collected in real time. Transactional data supports an organizations on-going processes which can include customers services. Some examples of these services can include: […]