LEARN TO CODE
LEARN TO CODE
Topics from the International Baccalaureate (IB) 2014 Computer Science Guide.
An organised collection of data that can be accessed, managed, and updated.
A single piece of information or data within a database record.
A collection of related data fields within a database.
A collection of related records within a database.
A person, place, thing, or concept within a database that can be uniquely identified.
A characteristic or property of an entity within a database.
A request for data from a database, often expressed in a specific language or format.
The ability of a database management system to allow multiple users to access and modify the database at the same time.
Database Management System, a software system that manages the storage and organization of data within a database.
A database transaction that is indivisible and must be completed in its entirety or not at all.
A set of properties that ensure database transactions are processed reliably: Atomicity, Consistency, Isolation, and Durability.
The property of a database transaction that guarantees that it is treated as a single, indivisible unit of work.
The property of a database transaction that guarantees that the database remains in a valid state before and after the transaction.
The property of a database transaction that guarantees that it is executed in isolation from other transactions.
The property of a database transaction that guarantees that once a transaction is committed, its changes are permanent and can survive system failures.
The property of a database that ensures the accuracy, completeness, and reliability of the data stored within it.
A set of operations that are executed as a single unit of work within a database.
The process of ensuring that the data entered into a database is correct and accurate.
The process of checking the accuracy and completeness of data stored within a database.
A sequence of operations that are executed as a single unit of work, such as inserting, updating, or deleting data within a database.
A database system in which all the data is stored in a single table.
A database system in which data is stored in multiple tables, each with its own unique key, and relationships between tables are established through keys.
A unique identifier for a record in a database table, used to establish relationships between tables.
A field in one table that refers to the primary key of another table, used to establish relationships between tables.
A combination of two or more fields that form a unique identifier for a record in a database table.
A field or combination of fields in a database table that could be used as the primary key.
A table used to establish a many-to-many relationship between two tables in a relational database.
The number of records in a table that are related to another table in a database.
A method of combining records from two or more tables in a database.
A query that retrieves data from a single table in a database.
A query that retrieves data from multiple tables in a database using various criteria and conditions.
Data that is duplicated or repeated unnecessarily within a database.
The consistency and accuracy of data relationships within a database, maintained through the use of primary and foreign keys.
The process of organising a database to minimise redundancy and maximise efficiency.
A relationship between three or more fields in a database table, in which a change in one field can affect other fields.
A field in a database table that is not used as a primary or foreign key.
Structured Query Language, a programming language used to manage and manipulate data in relational databases.
ALSO IN THIS TOPIC
RELATIONAL DATABASES 2.1 - 2.8
RELATIONAL DATABASES 2.9 - 2.20
DATABASE MODELS AND ANALYSIS
DATABASE KEY TERMINOLOGY
We would love to hear from you
To enjoy more benefits
We hope you find this site useful. If you notice any errors or would like to contribute material then please contact us.