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