ACC 525 - Exam 2

What are the five characteristics of big data?

5 V's

Velocity

Variety

Value

Volume

Veracity

Velocity

The speed at which data is generated

Value

The usefulness of data

most important

Volume

The quantity and scale of data generated every second

Veracity

The accuracy and truthfulness of data

What are the four categories within data analytics?

Descriptive analytics

Diagnostic analytics

Predictive analytics

Prescriptive analytics

Descriptive analytics - what question

What has happened?

Diagnostic analytics - what question

Why did it happen?

Predictive analytics - what question

What is likely to happen?

Prescriptive analytics - what question

How should we act?

What is a relational database?

A database that organizes structured data in interrelated tables connected by similarities between tables

What are the characteristics of a relational database?

includes tables that have records, column, field names, and fields

What are the four types of JOIN operations?

Inner Join

Left Outer Join

Right Outer Join

Full Outer Join

Inner Join retrieves

a record only if its join column value is present in both tables (matched)

Left Outer Join retrieves

records with a join column value present only in the first table of the JOIN (unmatched A) and the results of the inner join (matched A and B)

Right Outer Join retrieves

records with a join column value present only in the second table of the JOIN (unmatched B) and the results of the inner join (match A and B)

Full Outer Join retrieves

all records present in both tables of the JOIN (both matched and unmatched A and B)

What is documentation?

A formal record that describes a system or process

What are some of the purposes of documentation?

complying with laws and regulations

troubleshooting and maintenance

consistency across employees' work and how employees are trained

capturing usable information for process improvement

documenting and evaluating internal control activities

What are the four levels of documentation?

1. Systems documentation

2. Program documentation

3. Operator documentation

4. User documentation

What is Systems documentation?

Overview of the computer system with details of system design and architecture

What is Program documentation?

Detailed description of the system's programming logic and source code

What is Operator documentation?

Information necessary for the technical operator to execute and support the system

What is User documentation?

Instructions for system users on how to interact with the system

What are the five high-level business activities in inventory purchasing?

Inventory control

Purchasing - vendor selection and management

Purchasing - placing orders

Receiving

Account Payable

What is inventory control?

Determine the inventory to order

What is Purchasing - vendor selection and management?

Request availability and prices

What is Purchasing - placing orders

Order the inventory

What is Receiving?

Receive the inventory

What is Account Payable

Pay for the inventory received

Variety

The diversity of data created or collected