| ACID Properties |
A set of properties that ensure database transactions are processed reliably in a relational database system. |
| Composite Key |
A key that consists of two or more attributes that together uniquely identify a record. |
| Database Schema |
The structure that defines the organization of data within a database. |
| Entity |
An object or concept that can have data stored about it. |
| Foreign Key |
A field in one table that refers to the primary key in another table. |
| Indexes |
Data structures that improve the speed of data retrieval operations in a relational database. |
| Join |
A relational operation that combines data from two or more tables based on a related column between them. |
| Junction Table |
A database table that links two or more tables together. |
| Many To Many |
A relationship where multiple entities can be associated with multiple other entities. |
| Many-To-Many Relationship |
A type of relationship where multiple records in one table are associated with multiple records in another table. |
| Normalization |
The process of organizing data in a database to reduce redundancy and improve data integrity. |
| One To Many |
A relationship where a single entity can be associated with multiple entities. |
| One To One |
A relationship where a single entity is associated with exactly one other entity. |
| Primary Key |
A unique identifier for each record in a relational database table. |
| Relational Databases |
A type of database that stores and provides access to data points that are related to one another. |
| SQL |
Structured Query Language, used to communicate with and manipulate data in relational databases. |
| Tables |
An essential component of a relational database that organizes data into rows and columns. |
| Transactions |
A logical unit of work that is performed as a single, indivisible operation in a relational database. |
