What Is Relational Data Model?

The relational model is said to be a type of a Database management, it is a type of a database model that is based on the predicate logic and the set of theory. The relational model was first formulated in the year 1969 by Edgar Codd. The aim of this method included avoiding without the loss of completeness… it is used for the writing of computer programs which express the database in its integrity constraints.

Relational data model is the most commonly used data model to design the database. In 1970, Dr. Codd gave the concept of relational model, while he was working as a researcher at IBM. The relational model is based on mathematical theory, and therefore, has a solid theoretical foundation. This model represents a database as collection of relations, which are physically represented as tables or two-dimensional arrays. Similarly, the attributes are represented by columns of table and each row in a table represents a collection of related data values for a particular instance of an entity.

The relational data model consists of the following three components.
(i)       Data Structure: Data of various types can be organized in the form of tables or relations.
(ii)      Data   Manipulation:   Powerful   operations can be performed to manipulate data stored in the relations.
(iii)     Data Integrity: Data integrity rules can be applied to maintain data accuracy and data validity.
A database that contains multiple tables to store data and relationships can be created on the common fields of tables, is called relational database. The data in relational database is represented in the form of tables. In relational database, table is the basic structure in which data is stored.