Karteikarten
Chapter 2 Key Terms
Karten in diesem Stapel (15)
- 1Accounting Information SystemA system that records, processes, reports, and communicates the results of business transactions to provide financial and non-financial information for decision-making purposes.
- 2Composite Primary KeyA special case of a primary key that exists in linking tables. The composite primary key is made up of the two primary keys in the table that it is linking.
- 3Customer Relationship Management (CRM) SystemAn information system for managing all interactions between the company and its current and potential customers.
- 4Data DictionaryCentralized repository of descriptions for all of the data attributes of the dataset.
- 5Data Request FormA method for obtaining data if you do not have access to obtain the data directly yourself.
- 6Descriptive AttributesAttributes that exist in relational databases that are neither primary nor foreign keys. These attributes provide business information, but are not required to build a database. An example would be “Company Name” or “Employee Address.”
- 7Enterprise Resource Planning (ERP)Also known as Enterprise Systems, a category of business management software that integrates applications from throughout the business (such as manufacturing, accounting, finance, human resources, etc.) into one system.
- 8ETLThe extract, transform, and load process that is integral to mastering the data.
- 9Flat FileA means of storing data in one place, such as in an Excel spreadsheet, as opposed to storing the data in multiple tables, such as in a relational database.
- 10Foreign KeyAn attribute that exists in relational databases in order to carry out the relationship between two tables. This does not serve as the “unique identifier” for each record in a table. These must be identified when mastering the data from a relational database in order to extract the data correctly from more than one table.
- 11Human Resource Management (HRM) SystemAn information system for managing all interactions between the company and its current and potential employees.
- 12Mastering the DataThe second step in the IMPACT cycle; it involves identifying and obtaining the data needed for solving the data analysis problem, as well as cleaning and preparing the data for analysis.
- 13Primary KeyAn attribute that is required to exist in each table of a relational database and serves as the “unique identifier” for each record in a table.
- 14Relational DatabaseA means of storing data in order to ensure that the data are complete, not redundant, and to help enforce business rules. Relational databases also aid in communication and integration of business processes across an organization.
- 15Supply Chain Management (SCM) SystemAn information system that helps manage all the company’s interactions with suppliers.
Informationen
- Beschreibung
- Karteikarten am Chapter 2 Key Terms, erstellt von Matthew Evans am 23/01/2023.
- Erstellt von
- Matthew Evans
- Aufrufe
- 16
- Tags
- Bewertung