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.
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.
