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