MGT 268 MIDTERM FINAL
which is a BAD primary key?
PO#: On your customers POs
What is a field that uniquely identifies a given record in a table?
Primary key
@Spot the term that is NOT similar
(vending)
Which of the following statements is accurate?
-A typical business may have hundreds of business rules. - Each business rule will have entities and sometimes even attributes. - A correct business rule for one organization may not be correct for another organization.
What is an LC?
A bank document from the customer that allows the supplier to take payment directly from the bank based on proof of shipment
Which of the following is correct in reference to a database?
A database can support many logical views
What is a PR?
A document from any internal dept that informs the purchasing dept about their need of products/ services, requesting a purchase
What is a Proforma Invoice?
A document that shows the customer how the final Invoice might look like for the current order
What is a primary key?
A field (or group of fields) that uniquely identifies a given entity in a table
When could you expect a PO?
After a PR
Which of the following is an attribute about a person?
All on the List
What is the primary difference between an entity and an attribute?
An entity is a table that stores information about people, places, or events, where as an attribute is a column or specific field of the data elements associated with an entity
When could you expect a PR?
Before a PO
When could you expect an LOI?
Before a PO
When could you expect a DO?
Before shipping
Which of the following will enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints?
Business critical integrity constraints
Which of the following is a valid type of integrity constraint?
Business-critical integrity constraint
!Spot the term that is NOT similar
Buyer
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 request Create transfer order
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 LOI?
Customer, Purchasing dept
Who makes the PO?
Customer, Purchasing dept
Who makes the Goods Receipt note?
Customer, Shipping dept
Who receives the PL?
Customer, Shipping dept
Who makes the PR?
Customer, any internal department
Who makes the RFP?
Customer, purchasing department
Who makes the RFQ?
Customer, purchasing department
Which of the following uses a variety of techniques to find patterns and relationships in large volumes of information that predict future behavior and guide decision making?
Data-mining tools
What maintains information about various types of objects, events, people, and places?
Database
What compiles all of the metadata about the data elements in the data model?
Data dictionary
What is the smallest or basic unit of information?
Data element
What is the overall management of the availability, usability, integrity, and security of company data?
Data governance
What is a logical data structure that details the relationship among data elements using graphics or pictures?
Data model
Which of the following creates, reads, updates, and deletes data in a database while controlling access and security?
Database management system
What includes data that change based on user actions?
Dynamic information
Drew is a customer service representative and stores all of his customer information in a database.In a relational database model, what is a person, place, thing, transaction, or event about which information is stored?
Entity
In the relational database model, what is a person, place, thing, transaction, or event about which information is stored?
Entity
Which of the following stores information about a person, place, thing, transaction, or event, and is usually referred to as a table?
Entity
who created the GRN
GBI and MI sporting
Which of the following is true in regards to the elimination of redundant data?
Improves information quality
Which of the following is a disadvantage of database-stored information?
Increased data redundancy
When an organization combines the Procurement, Fulfillment and Production processes sharing data across from a single database, this is called an:
Integrated Process
What are rules that help ensure the quality of information?
Integrity constraints
A database maintains information on ___________.
Inventory Transactions Employees
What is an SO?
It converts the PO for internal departments to understand and coordinate work
What is the purpose of a PO?
It is a document from the customer to help create a formal agreement to purchase goods at specified terms and conditions.
What is an RFI?
It is a request to the supplier for more information about products/ services to help the customer decide what products/ services best fit their needs
Which of the following is not an example of an advantage to using the Web to access organizational databases?
It is cleaner and virus-free
What is the primary problem with redundant data?
It is difficult to determine which values are the most current It is often inconsistent It is difficult to determine which values are the most accurate
What is a DO?
It is the Accounting dept giving a go-ahead signal to the shipping dept to proceed with shipping out the goods
What is a DI?
It is the Shipping dept's instructions on how to delivery goods to the customer and includes transportation details such as the shipping route and number of shipments
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
What is a PL?
It shows what is packed in the in the box and which order is being fulfilled
Which of the following focuses on how individual users logically access information to meet their own particular business needs?
Logical view
Within the beginning stage of the data warehouse models process, which of the following are included in the internal databases?
Marketing, sales, inventory, and billing
Which of the following is a type of attribute?
Null-valued attribute Single-valued attribute Multi-valued attribute
Which of the following represents a reason an organization might encounter low-quality information?
Online customers intentionally enter inaccurate information to protect their privacy. - Different systems have different information-entry standards and formats. - Third-party and external information contains inaccuracies and errors.
What is a collection of related data elements?
Record
When considering data in a database entity, each row is a:
Record
What are rules that enforce basic and fundamental information-based constraints?
Relational integrity constraint
Master Data has all of the following characteristics, EXCEPT: 1. Stable 2. More Accurate 3. Represents Events 4. Used for Validation
Represents Events
RFP stands for?
Request for Proposal
RFQ stands for?
Request for Quotation
what does the response to the RFP consist of, and what is its business purpose
Response is the proposal it consists of the techno-commercial offer -detailed technical -detailed commercial
When could you expect a Proforma Invoice?
Right before or after a PO
When could you expect an LC?
Soon after a PO
What includes fixed data incapable of change in the event of a user action?
Static information
Which of the following asks users to write lines of code to answer questions against a database?
Structured query language
Some of the serious business consequences that occur due to using low-quality information to make decisions include all of the following except:
Success of the organization depends on appreciating and leveraging the low-quality information
Who makes the Invoice document?
Supplier, Accounting Department
Who makes the Proforma Invoice?
Supplier, Accounting dept
Who makes the DO?
Supplier, Accounting dept or Delivery dept
Who makes the SO?
Supplier, Sales dept
Who receives the PO?
Supplier, Sales dept
Who makes the DI?
Supplier, Shipping dept
Who makes the PL?
Supplier, Shipping dept
Who receives the SO?
Supplier, all internal departments
What is composed of rows and columns that represent an entity?
Table
Cathy is explaining where integration occurs between their basic business processes. Which of the following statements about an integrated process are TRUE?
The process is triggered by a customer order. The fulfillment process continues when the finished products become available The production process is suspended when the needed raw materials are not available.
what is the business purpose of LOI?
To promise the Supplier that the PO will be sent to them.
Which of the following statements concerning transaction data are true?
Transaction data are a consequence of the execution of process steps
What are the two different categories for information type?
Transactional and analytical
what is the business purpose of SO?
Unique SO# unique order identifier
RFI stands for?
a request for information
Invoice means
bill
A(n) ___________ represents all the tables in the database and their relationships in a simple graphical format
data model
DI stands for?
delivery instructions
DO stands for?
delivery order
Query by example:
is a technique that uses templates to retrieve and display data from a database
LC stands for?
letter of credit
LOI stands for?
letter of intent
PL stands for?
packing list
PO stands for?
purchase order
PR stands for?
purchase requisition
When considering a table in a Microsoft Access database, each "row" refers to a:
record
SO stands for?
sales order
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
Spot the term that is NOT similar
vendor