The relational model is an approach to managing data using a structure and language consistent with first-order predicate logic, first described in 1969 by English computer scientist Edgar F. Codd, where all data is represented in terms of tuples, and grouped into relations.
It’s the theoretical foundation of Relational Databases.
# Key terms
|Equivalent to a table; a set of tuples with the same attributes.
|A single row in a table, representing a single item or entity.
|Corresponds to a column in a table, with a specific data type.
|The set of all possible values an attribute can have.
|A unique identifier for each tuple in a relation. No duplicate values are allowed.
|An attribute that links two tables, referring to the primary key in another table.
|The formal description of a database’s structure, including tables, fields, relationships, views, and indexes.
|The number of elements in a set, or the number of tuples in a relation.
|The number of attributes in a relation.
|Rules to ensure accuracy and consistency of data across the database.
|A virtual table based on the result set of a query. Does not physically store data.
# Translation Layer (ORM)
If you use a relational model, and you use a Object-Oriented Programming languages, usually you need an akwardly layer that translates bettwen the relational model to the object-oriented model.
Usually these are called ORMs