BUAD 342 Exam 1

1. Identify a need 2. Internally request purchase order 3. Negotiate purchase order with vendor 4. Receive and Inspect goods or services from vendor 5. Store and or maintain goods 6. Pay vendor for goods or services 7. Return goods to a vendor

"Buy things" Business Event

____________________ describes the blueprint or design of the components of some information system and their relationships.

Architecture

used to calculate (sum, average, count, etc.) data that is grouped by two types of information - one down the left side of the datasheet and one across the top. The cell at the junction of each row and column displays the results of the query's calculation.

Crosstab Query

Customer_ID (primary key) Cust_first_name Cust_Last_name etc.

Customers ERD

to delete records from one or more tables, including using a criteria to specify which rows should be deleted

Delete Queries

files that contain inactive past or historical data. Examples could include tax return files from previous years or human resource files of employees who are no longer with the organization.

History Files

Which type of join will provide a designer with all the records that match from both tables?

Inner Join and Equi-join

What process is the Seller Side?

Order to Cash

Order_ID (primary key) Product_ID (foreign key) Order_price_per Quantity_ordered

OrderLines ERD

Order_ID (primary key) Customer_ID (foreign key) Employee_ID (foreign key) Order Date Required Date

Orders ERD

What is the name of the type of query that prompts a user for inputs before a query is run?

Parameter Query

What process is the buyer side?

Procure to Pay

Product_ID (primary key) Product_Name Supplier_ID (foreign key) Category_ID (foreign key) Unit List Price etc.

Products ERD

This document supports the Negotiate Purchase Order business event by summarizing the details (the who, what, where, when, and why) of each purchase order transaction

Purchase Order

Standardized Query Language that can be used to accomplish many tasks

SQL

Sales_Invoice_ID (primary key) Product_ID (foreign key) Sales_price_per Quantity_sold etc.

SaleLines ERD

Sales_Invoice_ID (primary) Order_ID (foreign key) Customer_ID (foreign key) Employee_ID (foreign key) Shipped_Date Shipper_ID (foreign key) Freight_charges etc.

Sales ERD

Once goods have shipped (POINT OF SALE) a _______________ is created and sent to the customer

Sales Invoice

This document supports the business event Deliver Goods or Services (the sale) by summarizing the details (the who, what, where, when, and why) of each sale transaction

Sales Invoice

Which of the following is not a source document related to Procure to Pay?

Sales Invoice

Which of the following source documents could be used to document the Negotiate Sales Order event?

Sales Order

This document supports the Negotiate Sales Order business event by summarizing the who, what, where, when, and why of each sales order transaction

Sales Order Document

1. Map Reality (Understanding of Business Process Needs) into Conceptual Model (e.g., E-R diagram or Object Oriented graphic) 2. Map Conceptual Model into Logical Model 3. Create Physical Database using DBMS software

Schema on Write process

Which data approach is more flexible?

Schema-on-Read

_______________________ simply records the data as-is, without making it conform to a particular model or predefined structure. Then organizations decide later how to process the data once they decide how they want to read and use it. A schema might not be determined until accessing data, based what is most relevant to the task at hand.

Schema-on-Read

When organizations use ________________________, this means that they define a schema (model) of the data up front, to build the structure that will house the data. Then when data is captured, it is recorded per the specified model. When organizations want to read the data, they access it using the schema (model) defined up-front.

Schema-on-Write

Use to view data from only certain fields in a table, review data from multiple tables simultaneously or pull data based on certain criteria.

Select Query

has information associated with it, such as metadata and tags.

Semi structured

Shipper_ID (primary Key) Shipper_Name Shipper_Phone

Shippers ERD

1. Capturing and Recording Source Data 2. Maintaining reference data 3. Generating Outputs/Reports

Some key information processing steps

collecting data at its point of origin in digital form

Source Data Automation (SDA)

traditional database which assumes data that will go into tables, so data is structured to fit that model

Structured

Supplier_ID (primary key) Supplier_Name Contact_Name Supplier_Address etc.

Suppliers ERD

____________contain data awaiting some action to complete their processing.

Suspense Files

files that contain data awaiting some action to complete their processing. Examples include customer payments waiting to be deposited or records identified as incomplete or erroneous that need correction and reentry to complete processing.

Suspense Files

Query Logic Step 2 includes the "From" statement from a SQL code. What is the designer capturing in the "From" statement?

The table(s) that holds the data

Which of the following scenarios would most likely benefit from real time processing instead of batch processing?

Ticket Reservations

Schema-on-write (traditional databases) Schema-on-read (big data repositories)

Two ways data is stored

to make changes to records from one or more tables, including using a criteria to specify which rows should be updated

Update Queries

differences in flows of data

Variability

Differences in types/sources of data - (structured, unstructured, and semi-structured).

Variety

1. Market goods or services to customers 2. Negotiate the terms of a Sales Order 3. Select and Inspect goods to be delivered to customer 4. Prepare goods or services for delivery to customer 5. Deliver goods or services to customer 6. Receive payment from customer 7. Negotiate terms of returns

"Sell things" business event

Transaction data is collected and stored for processing at a scheduled time or when a specified amount of data has been collected. (So master files that updated with transaction totals are not always up to date.) Examples: Payroll, Credit Card Transaction, Customer Billing, Customer Statements

Batch Processing

_________________ Databases are often referred to as NoSQL - Not only SQL or Not ordinary SQL - databases. Instead of applying schema on write (as we do in traditional relational databases), to define how data is captured, stored and queried, NoSQL databases use schema on read.

Big Data

refers to the dynamic, large and disparate volumes of data being created by people, tools and machines; it requires new, innovative and scalable technology to collect, host and analytically process the vast amount of data gathered in order to derive real-time business insights.

Big Data

Volume Velocity Variety Veracity Variability

Big Data Vs

This document supports the Deliver goods or services business event by summarizing the who, what, where, when, and why of the fulfillment of each sales order.

Bill of Lading

Extract (capture data) Transform (scrub/data cleansing) Load

Building a Data Warehouse

Extract, Transform, and Load describes the stages of:

Building a data warehouse

HOW do businesses do what they do?

Business Events

Which of the following describes WHAT a business does?

Business Processes

Category_ID (primary key) Category_Name Category_Description

Categories ERD

Which of the following is not a typical event in the Procure to Pay process? A.Identify a need B.Receive and Inspect goods or services from a vendor. C.Return goods to a vendor. D.All of the above are typical Procure to Pay events.

D

software is used to define, create, maintain, and provide access to data.

Data Base Management System (DBMS)

A central repository of information created with data from transactional systems, relational databases, and other sources.

Data Warehouse

No SQL is most often associated with A.Big Data B.Schema on Read databases C.Relational databases D.All of the Above E.Both A and B

E

Your boss asks you about ANSI X12 and EDIFACT. You explain to her that these concepts are standards for A.Database Design B.Business Events C.Source Data Automation D.Enterprise Resource Planning E.None of the Above

E

Employee_ID (primary key) emp_first_name emp_last_name etc.

Employees ERD

Magnetic Ink Character Recognition, Bar Code Reader/Scanner, Optical Character Recognition, Magnetic Strips on Credit Cards, Credit Card Chips, RFID, Touch Screens

Examples of Source Data Automation Technologies

This refers to the columns of a table

Fields

Files that contain balance data or the status of an entity at a point in time. Examples: inventory files, customer files, employee files, vendor files, or cash account files

Master Files

can be text or non text. Snap chats, tweets, mail messages, PowerPoint presentations, Word documents, text messages, JPEG images, MP3 audio files video files.

No Structure

This document supports the Prepare goods or services for delivery business event by summarizing the who, what, where, when, and why of the inventory selected to fulfill each sales order.

Packing Slip

prompts the query user for information to be used in executing the query. For example, use this type if you want a query that displays only the order ids for the customer id that the user inputs.

Parameter Query

The ___________________________ monitors the need to buy inventory through an inventory management system. This department then makes the purchase order.

Purchasing Department

Transaction data is immediately processed or close after the transaction occurs. (So master files that updated with transaction totals are kept current.) Examples: Airline or Ticket Reservation Systems Point of Sale (POS) Terminals

Real-Time Processing

This document supports the Receive Goods and Services (the purchase) business event by summarizing the details (the who, what, where, when, and why) of each receiving transaction

Receiving Report

A __________________ describes record field names, the width of each field, and the type of data stored in each field (e.g., numeric, alphanumeric, date).

Record Layout

This refers to the rows of a table

Records

files that files contain referential data such as a tax rate schedule, a volume pricing list, or a listing of the general ledger chart of accounts.

Reference Files

What is considered the point of sale?

The shipment of the goods

(a variation of a Select query) - You can use the Totals row in a basic Select query, but a Totals query allows you to ask more complex questions by grouping and summarizing data via the Sum function (an aggregate function).

Totals Query

A company keeps data about each completed purchase of inventory. What type of file is this data kept in?

Transaction File

files that contain business activity data (i.e., transaction data used to update balances in master files). Examples: order files, billing files, shipping files, and cash receipt files.

Transaction Files

Queries do more than just answer questions about data. Which type of query can make changes to records from one or more tables?

Update Query

Speed at which new data arrives. Data is being generated extremely fast —now more streaming data projects which allows the potential of near real time analysis.

Velocity

Differences in data accuracy/quality. Big data is sourced from many different places; as a result, you need to test the veracity and quality of the data the truth and the quality of the data, the usefulness of the data

Veracity

Which of the following describes the accuracy and usefulness of Big Data?

Veracity

More data- The amount of data being created is vast compared to traditional data sources. More of our own data (archive, junk, log files), added free or public data, premium service data.

Volume

to add records from one or more tables to the end of one or more other tables

append query

to create a new table using data from one or more existing tables

make-table query