Untitled Flashcards Set

Database

A collection of related data that represents aspects of the real world.

Database Management System (DBMS)

A software system to create, maintain, and manage a database.

CRUD

A set of operations: Create, Retrieve, Update, Delete performed on data.

Three-Schema Architecture

A framework that includes internal schema, conceptual schema, and external schemas for a database.

Entity-Relationship (ER) Model

A high-level data model that defines entities, relationships, and constraints.

Primary Key

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

Schema

The design or structure of a database, which is mostly static.

Relational Model

A data model based on relations (tables), tuples (rows), and attributes (columns).

SQL (Structured Query Language)

A standard language for querying and manipulating databases.

Entity

A real-world object or concept represented in the database.

Attribute

A property or characteristic of an entity.

Cardinality

The number of instances of one entity that can or must be associated with each instance of another entity.

Transaction

An atomic unit of work that ensures database integrity across operations.

Data Abstraction

Suppression of details to focus on essential features in data models.

Referential Integrity

A constraint that ensures that relationships between tables remain consistent.

Normalization

The process of organizing data to reduce redundancy and improve data integrity.

Foreign Key

An attribute that creates a link between two tables.