✦ScienexySCIENCE KNOWLEDGE LIBRARY
abbreviation · SCI-REF-007-770

Relational Database Abbreviations

Abbreviations describing relational database structures and operations.

Explanation

Abbreviations

AbbreviationFull FormMeaningUsage ExampleContext

PK

Primary Key

A column or combination of columns that uniquely identifies each row in a table.

A customer_id column can serve as a PK.

Relational table design.

FK

Foreign Key

A column or group of columns that references a key in another or the same table.

An order table may use customer_id as an FK.

Relationships and referential integrity.

ACID

Atomicity, Consistency, Isolation, Durability

Four properties that describe reliable database transaction behavior.

A transactional RDBMS aims to provide ACID guarantees.

Database transactions.

Example or application

A worked example has not yet been added.

Importance

These abbreviations are central to relational database design and reliable transaction processing.

Related Topic

  • Relational Databases

  • Database Design

  • SQL

Sources and verification

Sources are shown as provided in the project data. Not every source has yet been independently verified. Please report errors or missing citations.

  • Source verification pending; check an authoritative textbook, university, standards body, or peer-reviewed source.

Suggest a correction or source · More in Scientific Abbreviations & Acronyms