Project four, I use the Multitier Architecture pattern to label which folders are presentation, logic and data tiers. The files under register_product folder contain customer_login and product_register and are […]

Web site should use a cookie for authenticating access, tracking user’s browsing habits and storing user’s information. When cookies are stored on to the browser, the web server would retrieve the cookies and […]

If the error control operator(@) suppresses errors, what is the purpose of using it?

3.Error control operator suppresses the errors without reveling important information about the system.

The title, “Learn to code, get a job” sounds a bit overstated and misleading. Coding does not get you a job unless you devote more hours out of class to practice coding. You will not be successful by learning the […]

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

To determine whether the file in the directory is a executable, read, or write you can use is_executable(filename), […]

When is it preferable to use the “post” method and when is it preferable to use the “get” method?

Post is the preferred method when filling out sensitive information such as home address, credit card number and […]

Why would you want to count variables and words in a string? Can you provide an example?

Using the strlen() or str_word_count() function to count characters in a string gives the user the flexibility to limit […]

While statement is a type of loop statement as long as the expression is TRUE. The Do…while statement is similar in that it is loop statement but only require one time to execution when the expression is TRUE.

4. Primitive data types are single values. It contains integer numbers, floating-point numbers, boolean, string, null values. Reference data types contain multiple values and complex types of information, such as […]

2. Classification is based on human perspective and is very subjective. Clustering is used to determine distinct groups of data across multiple dimensions. It is useful for segmentation and focusing on different […]

2. This is an example of OLAP because as crime occurs, data are added and stored. These data are only useful for analyzing history of crime that occurred and it does not predict the future of crime.

1. Classification helps what group of data belongs to and it is mostly based on human perspective. One method of classification is to create a decision tree. A decision tree presents decisions rules also known as […]

The Chi-squared test and Gini index help the user decide when to split the decision tree using the formula for each predictor. This is useful for classifying a large amount of data and limiting the disproportional […]

Data mining is taking unknown and useful information from data to analyze and discover meaningful patterns or predictions. What data mining is NOT is analyzing sales, profit and sales force.

The key objectives for ETL is copying the data from the transactional database to analytical database, going from relational to dimensional data. The issues with ETL is data consistency and quality. It can lead to redundancy, different naming conventions, different unique identifiers.

a) understanding the needs of the organization & requirements by collecting information in a form of a question. b) defining the rows will help determine the data dimensions for each event. selecting an event for a particular data is very important. c) refining the business process by mapping the rows with key elements to answer [...]

2. “Drop” command deletes the entire table and its data. “Delete” command with or without a clause delete certain data.