Support is the number of times a particular piece of data appears in a data set.
Confidence is the strength of the relationship based on the amount of support that is in the data set.
Lift has to do with the […]

Data mining would be useful for a fire department to determine where most of their calls are as well as what type of calls are at these locations. This data could be used by the administration on determining […]

Classification and clustering are similiar in the fuction of grouping sets of attributes in a way that breaks down the information to be easier to understand. The difference between the two is that clusters come […]

Data mining is the extraction of implicit, previously unknown and potentially useful data. This data can be used to predict future outcomes or find human-interpretable patterns that describe data. Data mining is […]

The number of total voters as well as the breakdown between republican and democrat voters in each state is very important to an electoral candidate. With this data the candidate can determine how much time and […]

Delete refers to the deletion of a single record while Drop refers to the deletion of an entire table. An example of the Delete function would be to delete Than Lam from the Department table. To use the Drop […]

A situation that you would need to join multiple tables would be if you wanted to know how many people who lived in New Jersey bought Cheerios. This task would mean you would have to join the Customer table […]

Select * is a good command to use when you have no knowledge of the table you are querying. The problem with using this command all the time is the amount of time and work that the computer has to do in order to […]

In order to resolve a many to many relationship you must normalize the information. Through this organization of the data you will minimize redundancy so that the database takes up less space as well as having a […]

A primary key is a unique identifier for a particular table. This is important because it seperates all entities in a table with their own particular identifier. A foreign key is also a unique identifier but this […]

Information architecture of an organization can be catagoried into two fields. It can be a transactional database such as those performed in a database management system such as Oracle, My SQL or Access. The other […]