BUSINESS PROCESS MGT 268
GRN
Who makes the good receipts note?
What is a BAD primary Key? 1. Social Security # 2. Your SO # 3. Your Customer's PO# 4. Your Supplier's PO#
3. Your Customer's PO#
What is the business purpose of SO? Name any two. SO:
1. Unique SO# 2. Uniform layout with info for each department 3. Convert PO to your language, meter > feet 4. Have an execution plan 5. Have notes for internal departments
Master Data has all of the following characteristics, EXCEPT: 1. Stable 2. More Accurate 3.Represents Events 4. Used for Validation
3. Represents Events
LC
A bank document from the customer that allows the supplier to take payment directly from the bank based on proof of shipment
Data Dictionary
A collection of information that describes data types, uses, storage requirements, and rules that effect data.
Entity Relationship Diagram
A diagramming technique for designing databases which shows associations between entities and where each relationship can be labeled on the diagram
What is a PR?
A document from any internal department that informs the purchasing dept. about their need of products/services, requesting a purchase.
What is Proforma invoice?
A document that shows the customer how the final invoice might look like for the current order
Data Model
A logical data structure that details the relationship among data elements using graphics or pictures
What is a database management system?
A software application which one uses to create, store, organize, and retrieve data.
Another term for an entity is...
A table
When could you expect a PO?
After a PR
When could you expect an LOI?
Before a PO
When would you expect a PR?
Before a purchase order
When could expect a DO?
Before shipping
Spot the term that is not similar... (Vendor, buyer, seller, supplier)
Buyer
A disadvantage of a database approach to information management is:
Higher expenses
In the DBMS, the individual database is an...
Collection of related attributes about entities
Bad primary key? (#2)
Combination of last name and date of birth
A database key comprised of two or more attributes is called a...
Combination primary key
SQL is a...
Computer language
Shari is creating a process flow diagram of her company's integrated business processes, after which of the following activities should she include a decision point?
Create sales order, authorize production
Harry manages the warehouse and is delegating responsibilities to his employees on the show floor. Which of the following warehouse management steps are related to the procurement process?
Create transfer order Create transfer requirement
In a manual paper-based process, delays are caused due to which of the following?
Creating paperwork, sending paperwork
Who creates the PR?
Customer -- End-user department NOT Purchasing department.
Who makes the RFQ? Remember: Every company buys raw material and sells finished products, so every company is a 'Customer' when buying and a 'Supplier' when selling. You need to spot the right role and the right department.
Customer, Purchasing Dept
Who makes the RFP?
Customer, purchasing department
Who makes the RFQ?
Customer, purchasing department
Who makes the goods received note?
Customer, shipping department
Who receives the PL?
Customer, shipping department
Databases do one no good if they are not organized. The process of organizing and structuring databases efficiently is called:
Data Design
________ is the term used to identify whether a field is numeric, text, a date or time value, etc.
Data Type
What is a logical data structure that details the relationship among data elements using graphics or pictures?
Data model
What is a DI?
Delivery instructions
QBE
Enables us to fill out a grid/template in order to extract information from a database
In a relational database model, what is a person, place, thing, or transaction about which information is stored.
Entity
Who created the PL in Project-1? GBI, Spy Gear, and MI Sporting?
GBI and Spy Gear
When an organization combines the procurement, fulfillment, and production processes sharing data across from a single database, this is called...
Integrated process
What is a form?
Is a graphical user interface where the user can enter info or make choices, each of which represents an attribute or field within a database record
Data Type
Is the term used to identify whether a field is numeric, text, date, etc.
What is an LOI?
It is the written purchasing decision that informs a Supplier about the customer's intent to give them the PO in a few days
Letter of credit is given by a company to?
LC is given to Supplier--Sales or Accounting department
What is the purpose of a PO?
It's a document from the customer to help create a formal agreement to purchase goods at a specified terms and conditions.
What does LOI stand for?
Letter of Intent
Employees need to compare different types of information for what they commonly reveal to make strategic decisions. Which of the following represents the three common types of information found throughout an organization?
Levels, formats, and granularities.
How many entities can a database have?
Many
Which of the following is an attribute about a person?
Name, Social Security, and Salary.
How many products can a transaction have? How many transactions can a product have?
One transaction can have one or many products One product can go into zero or many transactions
A unique identifier for linking entities together is a:
Primary Key
PR stands for?
Purchase Requisition
Many DBMS packages such as Access have a simple way of interfacing with the databases using a concept called...
QBE
Which of the following enables us to fill out a grid or template in order to extract information from a database?
QBE
Name ONE document that may not have ANY goods mentioned in it?
RFI
What document precedes an RFQ ? Who makes it?
RFI Customer-- Purchasing/End-user Department
When considering data in a database entity, each row is a...
Record
By placing a key from one entity in the table of another entity, we are creating inevitable but necessary...
Redundancy
What is the most common DMBS model?
Relational
Master Data has all of the following characteristics, EXCEPT: 1. Stable 2. More Accurate 3. Represents Events 4. Used for Validation
Represents Events
What does RFP stand for?
Request for Proposal
What does RFQ stand for?
Request for Quotation
What does the response to RFP consist of, and what is its business purpose?
Response to RFP is the "Proposal". It consists of the techno-commercial offer: -Detailed Technical -Detailed Commercial
When can you expect a Proforma Invoice?
Right before/after a PO
Paul works in a company where its workers complete separate functional tasks in their own departments without regard to the consequences for the other components of the process or areas in the organization. Which of the following terms reflects this situation?
Silo Effect
Knowing the data type is useful because it helps the DBMS know how to:
Sort data, complete calculations, and allocate storage space.
Reason why we create a sales order...
Standardized order and convert customer language to yours and literal language make sure shipping by due date sales order has a unique number
Who receives the GRN?
Supplier receives it, and created by Shipping department/Customer--Accounting department.
Who makes the Proforma Invoice?
Supplier, Accounting Department
Who makes the Invoice document? Remember: Every company buys raw material and sells finished products, so every company is a 'Customer' when buying and a 'Supplier' when selling. You need to spot the right role and the right department.
Supplier, Accounting Dept
Who receives the SO? Remember: Every company buys raw material and sells finished products, so every company is a 'Customer' when buying and a 'Supplier' when selling. You need to spot the right role and the right department.
Supplier, all internal depts
Who makes the SO?
Supplier, sales dept
Who receives the RFP?
Supplier--Sales Made by customer purchasing.
A benefit of using data normalization is...
The elimination of data redundancy
Cathy is explaining where integration occurs between their basic business processes. Which of the following statements about an integrated process are TRUE?
The production process is suspended when the needed raw materials are not available. The fulfillment process continues when the finished products become available. The process is triggered by a customer order.
What is the business purpose of LOI?
To promise the Supplier that the PO will be sent to them.
Spot the term that is not similar.... (Client, vendor, buyer, customer)
Vendor
