The relational model is an abstract theory of data that is based on the mathematical theory whose principles were laid down by Dr. E.F. Codd. The relational model of Codd used certain terms and principles, which were not familiar in the data processing circles at that time. The terms that were used to describe the database properties and functions lacked the precision necessary for the formal theory that Codd was proposing. So a new set of terminology had to be evolved. The following table gives a list of the relational term and their corresponding informal equivalent(s).

The Relational Database Management Systems, as said above, are based on the relational model. The relational model, in turn, is a way of looking at data. It is a prescription for how to represent and manipulate data. More precisely, the relational model is concerned with three aspects of data: data structure, data integrity, and data manipulation.

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

IBM Mainframe Topics