Business Information Systems, Data Management, and Applied AI

Vocabulary flashcards covering core concepts of business information systems, relational databases, analytics types, and artificial intelligence principles.

Information

Data presented in a meaningful context that leads to changes in understanding, action, or decision-making; characterized as "a difference that makes a difference."

Data

Unprocessed, recorded facts and figures that lack contextual meaning until interpreted.

Knowledge

Understanding that arises from interpreting and applying data within an experiential context.

Supervised Learning

A machine learning approach where a model is trained using labeled examples or known relationships provided prior to the learning step.

Retrieval-Augmented Generation (RAG)

A technique that enables generative AI to answer questions outside its static training data by searching relevant sources and enriching the prompt before generating an output.

Five Components of an Information System

The framework consisting of hardware, software, data, procedures, and people that work together to produce useful information.

Procedures (Information Systems)

The documented operational instructions and rules specifying how human users interact with system components to enter data and execute tasks.

People (Information Systems)

Essential human actors who interact with the information system, provide inputs, and make decisions based on its output.

Transactional Data

Operational data that captures event-specific business occurrences, such as the amount and date of a customer order or delivery.

Master Data

Consistent, reusable core entity data shared across an enterprise, such as customer profiles, product specifications, and pricing terms.

Organizational Data

Data representing the structural and legal architecture of an enterprise, such as definitions of warehouses, plants, and storage locations.

Metadata

Descriptive data that defines the structure and organization of a database, including table names, field names, and entity relationships.

Prescriptive Analytics

An advanced analytics category that determines optimal decisions or actions (such as order timing and quantity to prevent shortages at minimum cost) using methods like linear programming or simulation.

Demand Forecasting

A business process that uses historical sales data combined with market trends to anticipate future customer purchase quantities.

Actionable Visualization

A business visualization designed to directly lead to a decision or prompt the next relevant question.

Database Data Hierarchy

The organizational hierarchy of stored data arranged from smallest to largest: byte/character, field, record, and table.

Field (Column)

A discrete attribute or data element representing a specific characteristic of an entity in a relational table.

Primary Key

A unique identifier assigned to each record in a database table that distinguishes every row and cannot be blank or duplicated.

Foreign Key

A field in a relational database table that links to and references the primary key of another table to establish relationships between records.

Many-to-Many Relationship Implementation

A database design strategy that uses an intermediate junction table (such as AdvisorStudent) containing foreign keys linking to both related parent entities.

Rolling Up

An OLAP analytical operation where detailed, granular data points (such as four quarterly sales figures) are consolidated into a higher-level summary (such as an annual total).

Data Cleansing

The data acquisition activity of detecting and correcting corrupt, inaccurate, or inconsistent records across sources (such as harmonizing "DC Bikes" and "DC Bikes Inc.").

Analytics

The end-to-end process of acquiring, analyzing, and publishing data to uncover patterns and enable data-driven business decisions.

Robot Autonomy

The operational capability of a physical robotic system to perform tasks at least partly without continuous, direct human control.

System Effectiveness

An evaluation criterion assessing whether an information or AI system successfully achieves its intended strategic business outcomes, distinct from resource efficiency.

Prompt Persona

A role or perspective assigned to a generative AI model within a prompt to directly shape the tone, style, and content of its output.