Final Flashcards
(69 cards)
Entities
Something you collect data about.
EX- people or class
Attributes
An individual field containing data describing an entity in a database.
Relationship
An association between entities in a database to enable data retrieval.
Form
a business document that contains some predefined data and may include some areas where additional data are to be filled in, typically for adding or modifying data related to a single record.
Query
method used to retrieve data from a database.
Structured Query Language (SQL)-
most common language used to interface with databases.
Online Transaction Processing (OLTP)-
immediate automated responses to the request from multiple concurrent transactions of customers.
Data Dictionary
A document prepared by database designers to describe the characteristics of all items in a database.
Data Warehouse
A repository containing data from multiple large databases and other sources that is suitable for direct querying, analysis , or processing.
Data Mart
A data warehouse that is limited in scope and customized for the decision support applications of a particular end-user group.
Business Intelligence
tools and techniques for analyzing data of past and current transactions to obtain an understanding of an organization’s performance.
Online Analytical Processing (OLAP)-
the process of quickly conducting complex analyses of data stored in a database, typically using graphical software tools.
Order-to-Cash-
the set of processes associated with selling a product or service.
Procure-to-Pay
the set of processes associated with procuring goods from external vendors.
Make-to-Stock
the set of processes associated with producing orders based on demand forecasts.
Make-to-Order-
the set of processes associated with producing goods based on customers orders
ERP
Enterprise resource planning. Acts to support core business processes
What Is a Supply Chain?
A collection of companies and processes involved in moving a product from the suppliers of raw materials to the suppliers of intermediate components, then to final production, and, ultimately, to the customer
What Is a Supply Network?
businesses have multiple suppliers, who have multiple suppliers
Supply Chain Strategy
Trade off between Supply Chain Efficiency and Supply Chain Effectiveness
Supply Chain Planning
involves multiple Supply Chain Management tools and modules working together to meet business needs and customer demands
Supply Chain Execution
focuses on the efficient and effective flow of materials, information, and financial transactions
Supply Chain Efficiency vs Effectiveness
–Supply Chain Efficiency
- Minimizes cost, but increases risk of stock-outs - May sacrifice customer service
–Supply Chain Effectiveness
-Maximizes likelihood of meeting objectives
Just-in-Time Production
Inventory delivered just as it is needed
–Minimizes stock and handling costs –Reduces obsolescence charges