abbreviation · SCI-REF-007-770Relational Database Abbreviations
Abbreviations describing relational database structures and operations.
Explanation
Abbreviations
| Abbreviation | Full Form | Meaning | Usage Example | Context |
|---|
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