2-Compare and contrast Classification, Clustering, and Association rule.

In comparison, classification, clustering, and association rule are all three data mining techniques which are used to better understand […]

1- Give an example of a problem where data mining would be useful. Then explain whether it would be an example of predictive or descriptive analytics.

A company, in trying to more efficiently market certain […]

Clustering and classification are both similar in that they place objects or observations into groups to better understand them. The main difference between them is that clustering does this using data, not […]

Using the Chi-Squared test with a decision tree, one can find whether or not groups of individuals are the same or different. A Chi-Squared value would result in a low P-value and thus different groups.

The […]

Data mining consists of looking through a large amount of data in order to find patterns among the information. This is done to tell you why something happened and help predict what will happen in the […]

1. What are the key OBJECTIVES and ISSUES of getting the information into the data mart (ETL)?

Extract, Transform, Load (ETL) involves coping data from the transactional database to the analytical database. […]

A) Chose the business process: it is essential to know what business process that model builds on. This is to ensure that the usability of the model and of the data warehouse.
B) Declaring the grain: this […]

The Delete statement is used to remove rows from a table and it is a DML command. An example of Delete would be: DELETE FROM table_name WHERE some_column=some_value.

The Drop statement is used to remove entire […]

SQL can be divided into two parts:

1- DML stands for Data Manipulation Language and it encompases query and update commands. Examples of this language are “Select”, “Update”, “Delete”, and “Insert Into”.

2- […]

My apologies, my class notes said this. I should have done more research into the topic before putting it down as an answer.

To correct myself: SQL and ERD have no relationship to each other in regards to […]

Is there any relationships between ERD and SQL?

There is certainly a relationship between an ERD and SQL. ERD, standing for Entity Relationship Diagram, is a representation of data in a visual format so that it […]

What advice would you give to make sure an ERD accurately represents the business event it is supposed to capture?

I would recommend two things, the first being that all the requirements have been met in the […]

2.What are primary key and foreign key and why do we need them?

A primary key is the primary characteristic of an entity. It is an attribute which makes the entity uniquely identifiable. A foreign key on the […]

Edward Lieber, Songzhen Lin, Zep Shemuale

1- Date of Birth/Age
2- Profession
3- Location
4- Email location (university.edu)
5- Links posted on friends’ profiles
6- Interests provided on profile
7- […]

Explain the information architecture of an organization.

The information architecture of an organization is made up of two distinct factors: the operational data store and the analytical data store. Every piece […]