MGT 268 Midterm for Parag Uma Kosalge

What is a 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

What is composed of rows and columns that represent an entity?

Table

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

Invoice means...

A bill

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

What is a foreign key?

A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables

What is the primary problem with redundant data?

All of the above are problems with redundant information.

Which of the following is a possible business rule?

All of these choices

Which of the following is a type of attribute?

All of these choices

Which of the following represents a reason an organization might encounter low-quality information?

All of these.

Which of the following is an attribute about a person?

All on the list

When could you expect a LOI?

Before a PO

When could you expect a DO?

Before shipping

Which of the following is a valid type of integrity constraint?

Business Critical integrity constraint

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 Invoice and Post goods issue

In a manual, paper-based process, delays are caused due to which of the following?

Creating paperwork AND sending paperwork

Who makes the PR?

Customer, Any Internal Department

Who creates the PR?

Customer, Any department that is not purchasing

What makes the PO?

Customer, Purchasing Department

Who makes the RFP?

Customer, Purchasing Department

Who makes the GRN?

Customer, Shipping Department

Who receives the PL?

Customer, Shipping Department

Who makes RFQ?

Customer, purchasing department

Who makes an RFQ?

Customer- Purchasing Department

What is the smallest or basic unit of information?

Data Element

What is a logical data structure that details the relationship among data elements using graphics or pictures?

Data Model

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

Which of the following creates, reads, updates, and deletes data in a database while controlling access and security?

Database Management System

Which of the below is not an example of an advantage of using a relational database?

Decreased information security

What does DO stand for?

Delivery Order

What includes data that change based on user actions?

Dynamic Information

Which of the following illustrates the primary concepts of the relational database model?

Entities, attributes, keys, and relationships

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

What is a characteristic of a table?

Field

Who created packing list in project 1

GBI and Spy Gear

When an organization combines the Procurement, Fulfillment and Production processes sharing data across from a single database, this is called an:

Integrated Process

Which of the following is a disadvantage of database-stored information?

Increase data redundancy

What are rules that help ensure the quality of information?

Integrity Constraints

What is an SO?

It converts the PO for internal departments to understand and coordinate work

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 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 a DO?

It is the accounting department giving a go-ahead signal to the shipping department to proceed with shipping out the goods

What is a PL?

It shows what is packed in the in the box and which order is being fulfilled

What does SO stand for?

Sales Order

What does LC stand for?

Letter of Credit

What does LOI stand for?

Letter of Intent

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

What does PL stand for?

Packing List

What is the primary tool that retrieves information and helps users graphically design the answer to a question?

Query-by-example Tool

What document precedes an RFQ

RFI

Name one document that may not have any goods mentioned on it, other than the check

RFI and PO Acceptance

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?

Receives shipment from vendor AND Create sales order

When considering a table in a Microsoft Access database, each "row" refers to a:

Record

Which of the following systems allow users to create, read, update, and delete data in a relational database?

Relational database management system

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

When can you expect a proforma invoice?

Right before or 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

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 receives the RFP?

Supplier -- Sales

Who receives the GRN?

Supplier Shipping

Letter of credit is given to a company by

Supplier and Sales OR Accounting

Who makes the Invoice document?

Supplier, Accounting Department

Who receives the PO?

Supplier, Sales Department

Who makes the DI

Supplier, Shipping Department

Who makes the packing list?

Supplier, Shipping Department

Who receives the SO?

Supplier, all internal departments

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 AND The production is suspended when the needed raw materials are not available AND the fulfillment process continues when the finished products become available

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?

Transnational and analytical

Which is a bad primary key (bad identifier)

Your customers PO#

A(n) _____________ is an organized collection of related data.

database

A(n) _____________ is a software application that manages the database and controls access to the data stored in the database.

database management system

What does the response to RFP consist of, and what is the business purpose?

o Response to the RFP is the "Proposal" o It consists of the techno-commercial offer: Detailed technical Detailed commercial

What is the purpose of SO?

o Unique SO# o Uniform layout with info for each department o Convert PO to your language, meter to feet o Have an execution plan o Have notes for internal departments

What does PO stand for?

purchase order

One of the primary goals of a database is to eliminate data redundancy by recording each piece of data in only one place in the database. What does the elimination of data redundancy do for a database?

recording each piece of information in only one place in the database, because it saves disk space, information updates are easier, and improves information quality.