Data Management and Database Systems

These flashcards cover key vocabulary terms and concepts in data management and database systems, providing definitions and insights based on the lecture notes.

Data Redundancy

Occurs when the same data is duplicated in multiple files of a database.

Data Discrepancy

Occurs when the same attribute in related data files has different values.

Data Dictionary

An automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security.

Entity-Relationship Diagram

A schematic of the entire database that describes the relationships in a database.

Operational CRM

Includes customer-facing applications such as tools for sales force automation, call center support, and marketing automation.

Data Mining

Allows users to find hidden relationships in data and identify patterns that describe groups.

Normalization

The process of streamlining data to minimize redundancy and awkward many-to-many relationships.

SQL

The most prominent data manipulation language used today.

OLAP

Enables users to view the same data in different ways using multiple dimensions.

Primary Key

A field identified in a record as holding the unique identifier for that record.

Forecasting

Involves using a series of existing values to determine what other future values will be.

Associations

In data mining, refers to relationships or patterns linked over time.

Sales Force Automation (SFA)

Modules in CRM systems that provide tools for managing sales prospects, contact information, and team selling.

Supply Chain Management (SCM)

A type of system that integrates supplier, manufacturer, distributor, and customer logistics processes.

Program-Data Dependence

An issue with traditional file systems where changes in data structure require changes in program code.

Data Quality

Relates to the accuracy and consistency of data, affecting data integration and processing.