Relational Database Management System
- Understanding the RDBMS terminologies.
- Knowing the various types of keys.
- Managing data with integrity rules.
- Using set operators to retrieve data.
As we have discussed in Chapter 2, relational model was proposed by E. F. Codd in the 1970s. In his paper on relational data model, Codd explained the concept of relational database based on relational theory of mathematics.
The data models, such as hierarchical and network did not provide data and structural independence, i.e., when data type or data characteristics were changed, the application program had to be changed too. Similarly, when data structures in these models were changed, the application program ...