Fundamentals of Database Systems

These flashcards cover key vocabulary related to database systems, including definitions and concepts from the lecture notes.

Data Model

A set of concepts to describe the structure of a database, operations for manipulating those structures, and constraints the database should obey.

Schema

The description of a database, including its structure, data types, and constraints.

Database State

The actual data stored in a database at a specific moment in time.

Logical Data Independence

The capacity to change the conceptual schema without altering the external schemas and their corresponding application programs.

Physical Data Independence

The capacity to change the internal schema without needing to modify the conceptual schema.

Data Definition Language (DDL)

A language used to specify the conceptual schema of a database and define internal and external schemas.

Data Manipulation Language (DML)

A language used to specify database retrievals and updates.

Client-Server Architecture

A model where client devices access services provided by centralized server systems.

Three-Schema Architecture

A framework consisting of internal, conceptual, and external schemas to define how data is stored, managed, and accessed.

Entity

An object or thing in the database that is represented by data.

Constraint

A restriction that must be enforced on the data within the database.