IB Computer Science A.2 the Relational Database Model Key Definitions

A query that retrieves data based on multiple conditions, often using logical operators like AND, OR, and NOT.

A subset of SQL used to define and manage the structure of a database.

A centralized repository that stores metadata about the data in a database.

The process of creating a visual representation of the data and its relationships within a database.

A structured, persistent collection of related data that can be efficiently queried, inserted, updated and deleted usually managed by a database‑management system (DBMS).

Software that creates, stores, retrieves, and manages data in one or more databases.

A blueprint that outlines how data is organised within a database.

Data that describes other data, providing information such as the content, format, source, or structure to help organize, find, and understand it.

A process used to organize data in a database to reduce redundancy and improve data integrity.

Instructions written in a query language (such as SQL) that retrieve and manipulate data from a database.

Occurs when the same piece of information is stored in multiple places within a database or a data storage system.

A fundamental concept in database management, ensuring that data remains reliable and accurate.

A type of DBMS that organises data into two-dimensional tables (relations) linked by keys.

A collection of data items with predefined relationships between them, organized as a set of tables with columns and rows.

A query that retrieves data based on a single condition or criterion.

People or groups who are affected by or interested in a new system. This includes users, clients, developers, managers, and investors.

A virtual table created by a query that presents data in a specific format without modifying the underlying tables.