MGT 268 Midterm
What is composed of rows and columns that represent an entity? Field Table Key Record
Table
What is an LC? This is a list of corrected items given by the supplier to the customer in cases where the PO had errors This is the list of creditors prepared by the Accounting dept to make sure the customers pay on time This is the citation or penalty levied by the customer on the supplier for delayed delivery, as per terms of payment A bank document from the customer that allows the supplier to take payment directly from the bank based on proof of shipment
A bank document from the customer that allows the supplier to take payment directly from the bank based on proof of shipment
Invoice means Incoming communication International voice A bill Insider voice
A bill
Which of the following is correct in reference to a database? A database can support only one logical view A database can support many physical views A database can support many logical views A database can support up to 3 logical views
A database can support many logical views
What is a PR? A document made by the purchasing officer that lists the items they need to buy from the suppliers A document from the purchasing dept specifying the products/ services needed from a supplier in a proposal A document from the customer requiring the suppliers to submit a proposal for a project A document from any internal dept that informs the purchasing dept about their need of products/ services, requesting a purchase
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? This is an Invoice that is Proforma, that is, it comes before the shipping is done A document that is nothing but the final Invoice but it is based on performance A Professional Invoice that carries with it legal terms and conditions that need to be followed A document that shows the customer how the final Invoice might look like for the current order
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 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 Characteristics or properties of an entity A field (or group of fields) that uniquely identifies a given attribute in a table
A field (or group of fields) that uniquely identifies a given entity in a table
What is a foreign key? A foreign key of one table that appears as an entity in another table and acts to provide a logical relationship between the two records A table that uniquely identifies a given record in a field A field that uniquely identifies a given record in a table 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
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
When could you expect a PO? After a PR After LC Before RFP Before a PR
After a PR
A database maintains information on ___________. Inventory Transactions Employees All of the above
All of the above
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? Reduces disk space requirements Makes updating information easier Improves information quality All of the above
All of the above
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 All of the above
All of the above
Which of the following is a possible business rule? A DVD title can have many copies DVDs can be purchased by many customers A customer can purchase many DVDs All of these choices
All of these choices
Which of the following is a type of attribute? Null-valued attribute Single-valued attribute Multi-valued attribute All of these choices
All of these choices
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. All of these choices.
All of these choices.
Which of the following is an attribute about a person? All on the List Name Social Security Number Salary
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 entity
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
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? (2 correct answers) Authorize Production Receive Shipment From Vendor Create Purchase Order Create Sales Order
Authorize Production Create Sales Order
When could you expect a PR? After the LC Before a PO After a PO Before an RFP Soon after the RFI
Before a PO
When could you expect an LOI? After the LC Soon after the RFI Before a PO After a PO Before an RFP
Before a PO
When could you expect a DO? Before shipping Soon after the RFI Soon after the GRN Before the LC Immediately after the BG
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? Quality business constraints Critical web constraints Business critical integrity constraints Web integrity constraints
Business critical integrity constraints
Spot the term that is NOT similar Supplier Seller Buyer Vendor
Buyer
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? (2 correct answers) Create transfer request Post goods issue Create transfer order Create invoice
Create transfer request Create transfer order
Who makes the LOI? Remember: Every company buys raw material and sells finished products, so every company is a 'Customer' when buying and a 'Supplier' when selling. You need to spot the right role and the right department. Customer, Sales dept Supplier, Purchasing dept Customer, Purchasing dept Supplier, Sales dept Supplier, any internal dept.
Customer, Purchasing dept
Who makes the PO? Remember: Every company buys raw material and sells finished products, so every company is a 'Customer' when buying and a 'Supplier' when selling. You need to spot the right role and the right department. Supplier, Sales dept Supplier, Purchasing dept Customer, Purchasing dept Customer, Sales dept
Customer, Purchasing dept
Who makes the RFP? Remember: Every company buys raw material and sells finished products, so every company is a 'Customer' when buying and a 'Supplier' when selling. You need to spot the right role and the right department. Supplier, Sales dept Customer, Sales dept Customer, any internal dept Supplier, Purchasing dept Customer, Purchasing dept
Customer, Purchasing dept
Who makes the RFQ? Remember: Every company buys raw material and sells finished products, so every company is a 'Customer' when buying and a 'Supplier' when selling. You need to spot the right role and the right department. Customer, Purchasing dept Supplier, Sales dept Customer, Sales dept Supplier, Purchasing dept Customer, any internal dept
Customer, Purchasing dept
Who makes the Goods Receipt note? Remember: Every company buys raw material and sells finished products, so every company is a 'Customer' when buying and a 'Supplier' when selling. You need to spot the right role and the right department. Customer, Purchasing dept Customer, Shipping dept Supplier, Purchasing dept Supplier, Shipping dept
Customer, Shipping dept
Who receives the PL? Remember: Every company buys raw material and sells finished products, so every company is a 'Customer' when buying and a 'Supplier' when selling. You need to spot the right role and the right department. incorrect Customer, Shipping dept Supplier, Shipping dept
Customer, Shipping dept
Who makes the PR? Remember: Every company buys raw material and sells finished products, so every company is a 'Customer' when buying and a 'Supplier' when selling. You need to spot the right role and the right department. Supplier, Purchasing dept Supplier, any internal dept Customer, Purchasing dept Supplier, any internal dept. Customer, any internal dept
Customer, any internal dept
What compiles all of the metadata about the data elements in the data model? Data entity Data element Data attribute Data dictionary
Data dictionary
What is the smallest or basic unit of information? Database management element Data element Data model Data integrity issue
Data element
What is the overall management of the availability, usability, integrity, and security of company data? Data Intelligence Data governance Data forbearance Data forecasting
Data governance
What is a logical data structure that details the relationship among data elements using graphics or pictures? Data model Data element Data mining tool Data mart tool
Data model
What is a logical data structure that details the relationship among data elements using graphics or pictures? Data model Data mining tool Data mart tool Data element
Data model
What maintains information about various types of objects, events, people, and places? Database Data model Data mining Data intelligence
Database
Which of the following creates, reads, updates, and deletes data in a database while controlling access and security? Database element Database management system Data governance Data File
Database management system
Which of the below is not an example of an advantage of using a relational database? Increased information quality Increased flexibility Decreased information redundancy Decreased information security
Decreased information security
DI stands for? Delivery Information Distribution Indent Distribution Intent Delivery Instructions Delivery Intent
Delivery Instructions
DO stands for? Delivery Order Direct Order Delivery Offer Distinct Offer
Delivery Order
What is a technique for document the entities and relationships in a database environment? Relational database model Database Entity-relationship diagram Data model
Entity-relationship diagram
Which of the following illustrates the primary concepts of the relational database model? Ethics, applications, keys, and relationships Entities, attributes, keys, and relationships Endeavor, aspire, control, and regulate Early, after, before, and future
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 Relationships Attribute Foreign key
Entity
In the relational database model, what is a person, place, thing, transaction, or event about which information is stored? Entity Relationships Attribute Foreign key
Entity
Which of the following stores information about a person, place, thing, transaction, or event, and is usually referred to as a table? Entity Extraction Attribute Foreign key
Entity
What is a characteristic of a table? Key Table Record Field
Field
Which of the following is true in regards to the elimination of redundant data? Uses additional hard disk space Makes performing information updates harder Improves information quality All of the above
Improves information quality
Which of the following is a disadvantage of database-stored information? Increased flexibility Increased performance Increased data redundancy Increased data integrity
Increased data redundancy
SO stands for? Sales Officer Special Order Sales Order Sold Order
Sales Order
When an organization combines the Procurement, Fulfillment and Production processes sharing data across from a single database, this is called an: Integrated Process Inter-Company Process Intra-Company Process Inter-Department System
Integrated Process
What are rules that help ensure the quality of information? Information integrity Integrity constraints Information quality Information ethics
Integrity constraints
What is an SO? It is the sales officer who will be dealing with the order from the customer It is a document created to specify special order requirements An SO is made for internal records of the sales department It converts the PO for internal departments to understand and coordinate work
It converts the PO for internal departments to understand and coordinate work
What is the purpose of a PO? It is nothing but the customer's shopping list of products and services, given to the supplier so they can do the necessary supply. It is a document from the customer to help create a formal agreement to purchase goods at specified terms and conditions. It orders the supplier to supply goods. The supplier has to obey this order as it is a legal document. It is a formal document that specifies which Purchasing Officer will deal with the order from the customer.
It is a document from the customer to help create a formal agreement to purchase goods at specified terms and conditions
What is the role of a foreign key? It is 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 It is a unique way to identify each record Is a field that uniquely identifies a give record in a table All of the above
It is 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 an RFI? It is the suppliers returning information to the customers about their products/ services that best match customer needs It is the customers returning information to the supplier about their specific needs and situation It is a request from the customer for more instructions on how to use the product/ service that is being provided by the supplier 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
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? Web browsers are much easier to use than a computer based database The Web interface requires few or no changes to the database model It is cleaner and virus-free It costs less
It is cleaner and virus-free
What is a DO? It is a customer order that has distinct characteristics that need a different business process than usual It is a special order from a regular customer that is routed directly to the shipping dept It is the Accounting dept giving a go-ahead signal to the shipping dept to proceed with shipping out the goods It is the delivery offer made by various competing transporters to ship at the lowest possible price
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? This is the transporter telling the supplier about how they Intend to Deliver the goods, such as the transportation route and number of shipments This is a shipping dept's master plan on how they intend to distribute the goods to the customers, including standard routes and number of shipments 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 This is the information given by the customer on how the goods need to be shipped to them, including the shipping route and number of shipments preferred
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? This is a list of corrected items given by the supplier to the customer in cases where the PO had errors A document from the customer requiring the suppliers to submit a proposal for a project It is the written purchasing decision that informs a Supplier about the customer's intent to give them the PO in a few days A bank document from the customer that allows the supplier to take payment directly from the bank based on proof of shipment
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? This is the list of all the products that any customer can expect from the supplier This is the list of all the payment due from the customer along with the due dates It is a list of items that were purchased by the customer and gives the order details It shows what is packed in the in the box and which order is being fulfilled
It shows what is packed in the in the box and which order is being fulfilled
LC stands for? Letter of Citation List of Corrected items Letter of Credit List of Creditors
Letter of Credit
LOI stands for? Letter of Instructions List of Instructions Late On Information Letter of Intent
Letter of Intent
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 Competitor and industry information, mailing lists, & stock market analysis Marketing information, and stock market analysis numbers
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? Composite entity Many-to-many relationship One-to-one relationship One-to-many relationship
One-to-many relationship
PL stands for? Product List Packing List Purchasing List Payment List
Packing List
What is a field that uniquely identifies a given record in a table? Foreign key Primary key Data mining key DBMS key
Primary key
PO stands for? Purchasing Officer Procurement Order Purchase Order Product Order
Purchase Order
PR stands for? Purchase Requisition Purchase Requirements Proposal Requisition Proposal Requirements
Purchase Requisition
What is the primary tool that retrieves information and helps users graphically design the answer to a question? Data mining tools Structured example language Query-by-example tool Relational query tool
Query-by-example tool
RFQ stands for? Rating for Quality Return of Quotation Return for Quality Request for Quotation
Request for Quotation
What is a collection of related data elements? Field Record Key Table
Record
When considering data in a database entity, each row is a: Record Data Dictionary Template File
Record
RFI stands for? Request for Information Rating for Instructions Request for Instructions Return of Information
Request for Information
RFP stands for? Return of Proposal Request for Proposal Rating for Purchase Return for Purchase
Request for Proposal
When could you expect a Proforma Invoice? Soon after the shipment Right before or after a PO Right before the final Invoice Soon after the RFI After the LC
Right before or after a PO
In a manual, paper-based process, delays are caused due to which of the following? (2 correct answers) Sending paperwork Increased inventories Increased cycle times Creating paperwork Reduced cycle times
Sending paperwork Creating paperwork
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? Enterprise Systems Silo Effect ERP Effect Cross-Functional
Silo Effect
When could you expect an LC? After a PR Before an RFP Immediately after the RFP Soon after a PO Soon after the shipment
Soon after a PO
What includes fixed data incapable of change in the event of a user action? Content creator Content editor Static information Dynamic information
Static information
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 Inability to accurately track customers Inability to identify selling opportunities Lost revenue opportunities from marketing to nonexistent customers
Success of the organization depends on appreciating and leveraging the low-quality information
Who makes the Invoice document? Remember: Every company buys raw material and sells finished products, so every company is a 'Customer' when buying and a 'Supplier' when selling. You need to spot the right role and the right department. Customer, Accounting dept Customer, Sales dept Supplier, Purchasing dept Supplier, Accounting dept
Supplier, Accounting dept
Who makes the Proforma Invoice? Remember: Every company buys raw material and sells finished products, so every company is a 'Customer' when buying and a 'Supplier' when selling. You need to spot the right role and the right department. Supplier, Accounting dept Customer, Purchasing dept Customer, Sales dept Supplier, Purchasing dept Customer, Accounting dept
Supplier, Accounting dept
Who makes the DO? Remember: Every company buys raw material and sells finished products, so every company is a 'Customer' when buying and a 'Supplier' when selling. You need to spot the right role and the right department. Supplier, Shipping dept Supplier, Accounting dept or Delivery dept Customer, Purchasing dept Supplier, Purchasing dept Customer, any internal dept
Supplier, Accounting dept or Delivery dept
Who makes the SO? Remember: Every company buys raw material and sells finished products, so every company is a 'Customer' when buying and a 'Supplier' when selling. You need to spot the right role and the right department. Customer, Purchasing dept Supplier, Sales dept Customer, Sales dept Supplier, Purchasing dept
Supplier, Sales dept
Who receives the PO? Remember: Every company buys raw material and sells finished products, so every company is a 'Customer' when buying and a 'Supplier' when selling. You need to spot the right role and the right department. Customer, Sales dept Customer, Purchasing dept Supplier, all internal depts Supplier, Purchasing dept Supplier, Sales dept
Supplier, Sales dept
Who makes the DI? Remember: Every company buys raw material and sells finished products, so every company is a 'Customer' when buying and a 'Supplier' when selling. You need to spot the right role and the right department. Supplier, Accounting dept Customer, Purchasing dept Customer, Sales dept Supplier, any internal dept. Supplier, Shipping dept
Supplier, Shipping dept
Who makes the PL? Remember: Every company buys raw material and sells finished products, so every company is a 'Customer' when buying and a 'Supplier' when selling. You need to spot the right role and the right department. Customer, Shipping dept Supplier, Shipping dept Supplier, Purchasing dept Customer, Purchasing dept
Supplier, Shipping dept
Who receives the SO? Remember: Every company buys raw material and sells finished products, so every company is a 'Customer' when buying and a 'Supplier' when selling. You need to spot the right role and the right department. Supplier, Sales dept Supplier, Purchasing dept Customer, all internal department Supplier, all internal depts Customer, Sales dept
Supplier, all internal depts
Cathy is explaining where integration occurs between their basic business processes. Which of the following statements about an integrated process are TRUE? (3 correct answers) The fulfillment process continues when the finished products become available. The process is triggered by a customer order. The fulfillment process is suspended when the needed raw materials are not available. The production process continues when the finished products become available. The production process is suspended when the needed raw materials are not available.
The fulfillment process continues when the finished products become available. The process is triggered by a customer order. The production process is suspended when the needed raw materials are not available.
Which of the following statements concerning transaction data are true? Transaction data are a consequence of the execution of process steps Transaction data are big numbers Transaction data change infrequently Transaction data represent entities such as customer and vendors
Transaction data are a consequence of the execution of process steps
What are the two different categories for information type? Analytical and productive Analytical and analysis Transactional and productive Transactional and analytical
Transactional and analytical
Spot the term that is NOT similar Vending Procurement Buying Purchasing
Vending
Spot the term that is NOT similar Client Customer Buyer Vendor
Vendor
The process of retrieving and displaying data from a database is called: a query a removal an extraction a filtration
a query
A(n) ___________ represents all the tables in the database and their relationships in a simple graphical format. data model report table entity map
data model
A(n) _____________ is an organized collection of related data. database forum table DBA
database
A(n) _____________ is a software application that manages the database and controls access to the data stored in the database. database management system OLAP network query by example
database management system
Query by example: is a technique that uses templates to retrieve and display data from a database is a language for manipulating the contents of a database is a technique to graphically display relationships among entities is a technique to generate print-outs of customized database reports
is a technique that uses templates to retrieve and display data from a database
When considering a table in a Microsoft Access database, each "row" refers to a: record file data dictionary template
record
