Closed Frequent Item Sets

Answer the following questions based on the data sets shown in Figure 1. Note that each data set contains 1000 items and 10000 transactions. Dark cells indicate the presence of items and white cells indicate the absence of items. We will apply the Apriori algorithm to extract frequent item sets with...

Database, subqueries, and joins

•Think of a purpose for creating a database and describe the database. Explain why you would want to use a database for this purpose. •What example could you offer that would demonstrate using a subquery? •What example could you offer that would demonstrate using a join? •In your view, w...

MS Access 2013 Form: Processing Multiple Tables

Have a database for which Im trying to create a form to input the same data for multiple instruments at the same time, with no luck. For now just trying to get GC 2 and GC 5 on the same form to input the data - I have started the form (Fm_GC) and would like for it to be workable, and for data to go ...

Inputs, criteria, and analysis of a small publishing company

I need advice on how to do this question. A small magazine publisher wants to determine the best combination of two possible magazines to print for the month of July. Backyard magazine, which he has published for years, is a steady seller. The publisher wants to make sure he prints at least 400 c...

Structured Query Language Skills

Customer Volume by Month • CustomerID • Month • Total shipments • Total weight Driver Performance by Month • Driver ID • Month • Number of manifests on time • Number of manifests delivered late In order to create the SQL select statements that would produce running summary ...

How to Print an Excel Document Correctly

I have lots of information that is spread across quite a few columns and it runs down many rows. When I hit print, it cuts off the data in weird spots and gives me extra pages that are hard to read, since my data labels are all on the left side. I know that I should switch it to Landscape orienta...

Extracting a Certain Text File from a File

See the attached file. I have a text file containing sentences and random sequences of letters, symbols and numbers. I have to write a program that will extract only the text sent to a particular device and ignore the rest of the messages. Each message sent has an identifying two characters header ...

Excel: Worksheets and Workbooks

What is the difference between a workbook and a worksheet? Why would you want to use separate worksheets when using Excel? Please give 2 general examples. Please research and find the method for creating an Excel formula that references information on the first worksheet from a second worksheet. Can...

Entity-Relationship Diagram using the Conceptual Data Model

Subject: Data Mining and Warehousing Topic: Create an entity-relationship diagram using the conceptual data model. Description: You are asked you to create a new entity-relationship diagram for a company (Moonlight Distributors) for a customized shipment tracking system. Study level: BA Questio...

Girl Scout Cookies: Working with Excel

Open the Excel file called "Girl Scout Cookies.xls". Follow the steps below. If you make an error, use the UNDO button to undo the error. 1. Widen column A to a width of 12. (Hint: select the column, click format, click column) 2. Widen column B to a width of 10. 3. Make columns C through J a w...

Book Store Problem: Working with Excel

Open the Excel file called "Book Store.xls". Follow the steps below. If you make an error, use the UNDO button to undo the error. 1. Widen column A to a width of 12. (Hint: select the column, click format, click column) 2. Widen column B and C to a width of 10. 3. Make columns D through J a wid...

Channel bandwidth and backup requirement

Consider an organization, which has a rented communications channel between two buildings, A and B. They have a set of servers in building A, and wish to back up critical data on an hourly basis to a set of storage drives in building B. They know that the channel has a bandwidth of 10KHz and a signa...

Project management risk

You have been assigned as the manager on a project to develop a new application system for your business partner. You were given two weeks to develop a project plan and high level cost estimates. Unfortunately, this is a relatively new technology for the company, and although the technology has bee...

Computer passwords

Before logging on to the computer, you must have a unique username and password. Research and describe considerations you must make when choosing a password. Include reasons why a secure password is important. (Answer provided in approximately 100 words.)

BI, data warehousing, data mining

What are important questions that a university might be able to answer by warehousing and mining student records and learning management system data?

Data Mining to detect fraud

The tax authorities working for various governments are often confronted with the challenge of detecting tax evasion and fraud. Imagine you work at the income tax department. All residents and businesses of the country earning income should file tax information electronically along with their tax pa...

Customer Analysis on Annual Reports

Problem: I need to make order predictions for next year, based on the data in the table. Table "NUMBER OF TOOL ORDERS PER YEAR" should be represented on charts, type of chart is not important. Table "ORDER PREDICTIONS FOR NEXT YEAR" should be presented on charts too. table is attached ...

Explain data integrity

Data integrity falls into the following categories: -Entity integrity -Referential integrity -Domain integrity -User-defined integrity Explain them.

Adverse affect on fundamental business decisions

Can the speed in which information is transmitted have an adverse affect on fundamental business decisions?Yes, speed that is traveling at high rates of speed can have an affect on fundamental business decisions. Businesses are constantly expanding everyday and expanding requires them to develop ne...

Computer Problems.

Please see attached file for the problems. 1. Commonly, medical digital radiology ultrasound studies consist of about 25 images that are extracted from a full-motion ultrasound examination. Each image consists of 512 x 512 pixels. Each pixel is represented by an 8-bit scale for intensity. ...

Data, Information, and Organizational knowledge

Please explain how data, information and knowledge are related to the concept of knowledge management (KM)? How are they different (please define each one: data, information, knowledge and KM)? What are the potential benefits of knowledge management projects? What strategies should companies follow...

Greedy strategy to find shortest path between two vertices

Consider the following greedy strategy for finding a shortest path from vertex start to vertex goal in a connected graph. 1: Initialize path to start. 2: Initialize VisitedVertices to {start}. 3: If start=goal, return path and exit. Otherwise, continue. 4: Find the edge (start,v) of the minimu...