MGT 268 Midterm

Which 3 documents need to match for the accounting people to make a payment? - PO, PL, Invoice - PO, GRN, Invoice - PO, SO, GRN - PO, SO, Invoice

PO, GRN, Invoice

An SO document has multiple uses. Choose all that are applicable: - It converts customer's language and units of measurement and products to your own - It has a standard format with data separated by departments, making it easy for departments to begin working immediately - It is an internal document, so it allows Salesperson to share personal comments about the customer and the order with all departments - It is a document filed by sales department for internal record keeping purposes only - It has an Order Execution Plan that allows distribution of work and helps collaboration and coordination

- It converts customer's language and units of measurement and products to your own - It has a standard format with data separated by departments, making it easy for departments to begin working immediately - It is an internal document, so it allows Salesperson to share personal comments about the customer and the order with all departments - It has an Order Execution Plan that allows distribution of work and helps collaboration and coordination

What are the two symbols for "Many"? - 1-or-many - 1-to-many - 0-to-many - 0-or-many

1-or-many and 0-or-many

What is a PR? - A document from the customer requiring the suppliers to submit a proposal for a project - A document from the purchasing dept specifying the products/services needed from a supplier in a proposal - A document from any internal dept that informs the purchasing dept about their need of products/services, requesting a purchase - A document made by the purchasing officer that lists the items they need to buy from the suppliers

A document from any internal dept that informs the purchasing dept about their need of products/services, requesting a purchase

What is a primary key? - Characteristics or properties of an entity - A field (or group of fields) that uniquely identifies a given entity in a table - A field (or group of fields) that uniquely identifies a given attribute in a table - A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables

A field (or group of fields) that uniquely identifies a given entity in a table

The process of retrieving and displaying data from a database is called: - An extraction - A removal - A filtration - A query

A query

Which of the following is a possible business rule? - All of these choices - A customer can purchase many DVDs - A DVD title can have many copies - DVDs can be purchased by many companies

All of these choices

Which of the following is an attribute about a person? - Social Security Number - All on the list - Salary - Name

All on the list

What is the primary difference between an entity and an attribute? - An attribute is a table, an entity is a column from the attribute table - An entity is specific, where as an attribute is not data at all but brainstorming ideas that take place before the entity is created - An attribute refers to applications, and an entity refers to executives - 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 entry

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 entry

When could you expect an LOI? - After a PO - Soon after the RFI - Before a PO - Before an RFP - After the LC

Before a PO

A database key comprised of two or more attributes is called a(n): - Conjoined twins - Concatenated Primary Key - Combination Primary Key

Combination Primary Key

Shari is creating a process flow diagram of her company's integrated business processes, after which of the following 2 activities should she include a decision point? - Create Purchase Order - Create Sales Order - Authorize Production - Receive Shipment from Vendor

Create Sales Order and Authorize Production

Harry manages the warehouse and is delegating responsibilities to his employees on the show floor. Which 2 of the following warehouse management steps are part of the procurement process? - Create Invoice - Post goods issue - Create outbound delivery - Create Transfer Order - Create Transfer Request

Create Transfer Order and Create Transfer Request

The Comparative statement is created by: - Customer, Sales - Supplier, Purchasing - Customer, Purchasing - Supplier, Sales

Customer, Purchasing

Who makes the LOI? - Customer, Purchasing dept - Supplier, Purchasing dept - Supplier, Sales dept - Customer, Sales dept - Supplier, any internal dept

Customer, Purchasing dept

Who makes the RFP? - Supplier, Sales dept - Customer, Sales dept - Customer, Purchasing dept - Supplier, Purchasing dept - Customer, any internal dept

Customer, Purchasing dept

Who receives the PL? - Supplier, Shipping dept - Customer, Shipping dept

Customer, Shipping dept

A Purchase Requisition is created by the: - Supplier, Sales - Customer, Purchasing department - Customer, end-user department - Supplier, Purchasing department

Customer, end-user 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 integrity tools - Electronic analysis tools - Data-mining tools - Data analysis tools

Data-mining tools

What is the overall management of the availability, usability, integrity, and security of company data? - Data forbearance - Data forecasting - Data governance - Data intelligence

Data governance

A(n) _______ represents all the tables in the database and their relationships in a simple graphical format. - Entity map - Data model - Report - table

Data model

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 - Foreign key - Attribute - Relationships

Entity

The nature of the Foreign Key is such that: (Choose 3) - In the table the Foreign Key is present, it will be 'Duplicates Okay' - This is a key that allows 2 tables to connect with each other, especially when there is nothing else in common - A Foreign Key in one table is a Primary Key in another table - It is just another name for Primary Key

In the table the Foreign Key is present, it will be 'Duplicates Okay' This is a key that allows 2 tables to connect with each other, especially when there is nothing else in common A Foreign Key in one table is a Primary Key in another table

Which of the following is a disadvantage of database-stored information? - Increased data integrity - Increased performance - Increased flexibility - Increased data redundancy

Increased data redundancy

When an organization combines the procurement, fulfillment, and production processes sharing data across from a single database, this is called an: - Inter-department system - Inter-company process - Integrated process - Intra-company process

Integrated process

A master data has all the following characteristics EXCEPT: - It is stable - It is more accurate - It is used for validation - It represents events

It represents events

What is a PL? - It is a list of items that were purchased by the customer and gives the order details - It shows what is packed in the box and which order is being fulfilled - This is the list of all the payment due from the customer along with the due dates - This is the list of all the products that any customer can expect from the supplier

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

A proforma invoice is used to: - Bill the customer for proforma supply of goods - Invoice your customer for the advance money they gave you - Let your customer know how your final bill would look like - Bill the customers for goods you have already provided - Bill the customers for the goods you are about to ship

Let your customer know how your final bill would look like

Which relationship is a BAD relationship in Database design? - 1-to-many - Many-to-1 - Many-and-many - Many-to-many

Many-to-many

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 - Data mart 1, data mart 2, data mart 3 - Marketing information and stock analysis numbers - Competitor and industry information, mailing lists, and stock market analysis

Marketing, sales, inventory, and billing

What occurs between two entities in which an instance of one entity can be related to many instances of a related entity? - One-to-one relationship - One-to-many relationship - Composite entity - Many-to-many relationship

One-to-many relationship

What are the two types of queries? - Query by Language - Query by Access - Query by Example - Query by Report

Query by Language and Query by Example

What is a collection of related data elements? - Field - Record - Key - Table

Record

When considering data in a database entity, each row is a: - Template - Record - File - Data Dictionary

Record

What are rules that enforce basic and fundamental information-based constraints? - Integrity constraint - Information integrity - Relational integrity constraint - Business-critical integrity constraint

Relational integrity constraint

What are the rules that enforce basic and fundamental information-based constraints? - Information integrity - Relational integrity constraint - Integrity constraint - Business-critical integrity constraint

Relational integrity constraint

What does the response to RFP consist of, and what is its business purpose? -You respond an RFP with an RFQ that gives the detailed price quotation - Response to RFP is the 'Proposal', a techno-commercial offer, that contains detailed Technical and detailed Commercial items - You need not respond to an RFP, it is one of the documents that you receive from a supplier - You respond to the RFP with an RFI document that gives the details of your requirements

Response to RFP is the 'Proposal', a techno-commercial offer, that contains detailed Technical and detailed Commercial items

When could you expect a Proforma Invoice? - Right before or after a PO - Soon after the shipment - Right before the final invoice - Soon after the RFI - After the LC

Right before or after a PO

The Order table Primary key: should it be PO# or SO#? Why? (Choose 2) - PO# because PO#s are from the customer and they are always unique - SO # because our company makes the SOs - SO# because our company creates and controls the SO#s - PO# as PO is a legal document

SO # because our company makes the SOs SO# because our company creates and controls the SO#s

When could you expect an LC? - Soon after the shipment - After a PR - Immediately after the RFP - Before an RFP - Soon after a PO

Soon after a PO

What includes fixed data incapable of change in the event of a user action? - Static information - Content creator - Content editor - Dynamic information

Static information

Who makes the DO? - Customer, any internal dept - Supplier, Accounting dept or Delivery dept - Supplier, Shipping dept - Supplier, Purchasing dept - Customer, Purchasing dept

Supplier, Accounting dept or Delivery dept

Who makes the SO? - Customer, Sales dept - Supplier, Purchasing dept - Customer, Purchasing dept - Supplier, Sales dept

Supplier, Sales dept

A Letter-of-credit is given by a business to their _______ to allow a business deal to happen. - The Bank - Customer, Sales department - Supplier, Sales or Accounting - To their Customer, Accounting department

Supplier, Sales or Accounting

What's the difference between an RFQ and an RFP? - The response to an RFQ is a big document requiring much more than just the price - The response to an RFP is a big document requiring much more than just the price - RFQ is usually for big, complex requirements - There is no difference between them. They are similar terms.

The response to an RFP is a big document requiring much more than just the price

Which of the following statements concerning transaction data are true? - Transaction data are big numbers - Transaction data change infrequently - Transaction data are a consequence of process steps - Transaction data represent entities such as customer and vendors

Transaction data are a consequence of process steps