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