Database Systems and Data Management

Flashcards covering key vocabulary and concepts related to database systems and data management.

Database

A well-designed, organized, and carefully managed collection of data that helps an organization achieve its goals.

Data

Raw facts used for analysis and decision making.

Information

Organized and processed data that has additional value beyond individual facts.

Knowledge

Awareness and understanding of information that supports specific tasks or decisions.

Alphanumeric data

Data represented by numbers, letters, and other characters.

DBMS (Database Management System)

A group of programs used to access and manage a database.

Primary key

An attribute or set of attributes that uniquely identifies a record in a database.

Foreign key

An attribute in one table that refers to the primary key in another table.

ACID properties

Atomicity, consistency, isolation, and durability; these ensure reliable processing of transactions in a database.

Data Cleansing

The process of detecting and correcting inaccurate or irrelevant records in a database.

Entity-relationship (ER) diagram

A data model that analyzes and communicates data needs using graphical symbols to show data entities and their attributes.

SQL (Structured Query Language)

A special-purpose programming language used for accessing and manipulating relational database data.

Data Normalization

The process of eliminating data redundancy within a relational database.

Database as a Service (DaaS)

A service where databases are stored on a provider's servers and accessed over the Internet.

Data Lifecycle Management

A policy-based approach for managing a company's data from creation to deletion.

The Value of Information

The degree to which information helps decision makers achieve organizational goals.

Schema

A description defining the logical and physical structure of a database, including tables and relationships.

Data Dictionary

A detailed description of the data stored in the database and its structure.

High-Quality Data

Data that is easily accessible, error-free, complete, relevant, and timely.

Manipulating Data

The process of accessing, modifying, and generating reports from a database.

Data Governance

Defines roles and processes ensuring data can be trusted and properly managed within an organization.

Data Steward

An individual responsible for the quality and fitness of an organization’s data assets.