Database Systems Overview

These flashcards cover key vocabulary related to database systems, including concepts, definitions, and roles.

Data Redundancy

The duplication of data in a database, which can lead to inconsistency.

Metadata

Data that provides information about other data, such as its meaning, relationships, and constraints.

SQL

A programming language used to manage and manipulate relational databases.

Conceptual Data Model

A high-level representation of the data requirements and organization of a database.

Logical Data Model

Maps conceptual data models into storage details.

Database State

The current contents of a database at a specific point in time.

DDL (Data Definition Language)

A syntax for defining database structures, such as tables and schemas.

ACID Durability

Ensures that once a transaction has been committed, it remains permanent, even in the event of a system failure.

Data Steward

A role responsible for managing and ensuring data quality compliance.

UML Association Class

A UML feature that allows relationships between entities to have attributes.

Weak Entity

An entity that cannot be uniquely identified by its own attributes alone and depends on another entity.

Metadata Definition

Data that describes the structure, rules, and characteristics of other data.