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
