What Is Relational Data Model?
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
