Link to extra credit assignment:

http://community.mis.temple.edu/jeffhickson/?page_id=97

Are you kidding me man?? LOL

Data Mining is the extracts information to discover patterns and other trends in the data set. It does not analyze business statistics such as company profitability.

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

The key objectives and issues of getting the information into the data mart (ETL) are:

1. To use the process of […]

Describe the objective and activity of Kimball’s Four Step Process for Data Cube Design:
a) choosing the business process,
Determining what the business process is all about and what questions to […]

DELETE is a DML command and is used to delete a field from a table. DROP is a DDL command and is used to drop a table. Example: DELETE is used to delete a phone number, address, zip code, etc… The DROP […]

DML and DDL are both used to change information. DML (Data Manipulation Language) commands are used to modify tables; using Select, Update, Delete or Insert info. DDL (Data Definition Language) are used to […]

Yes, there is a relationship between ERD and SQL. As a matter of fact there is a direct relationship between the two. Through the processes of forward and reverse engineering, the relationship between them is […]

To resolve the many to many relationship, a new table has to be created. One table must consist of a primary key and the other has to have a foreign key to relate them to each other. A new relationship between […]

Normalization centralizes data into one place so that multiple databases aren’t created with the same information. It is also more efficient when updating information because it is done in one place instead of […]

Transactional data is the raw, real time, unorganized information that is stored for future analysis and documentation. Analytical data is the transactional data that has been manipulated to be used to make sound […]