CHAPTER 3

Relational Database Management System

CHAPTER OBJECTIVES
  • Understanding the RDBMS terminologies.
  • Knowing the various types of keys.
  • Managing data with integrity rules.
  • Using set operators to retrieve data.
3.1 INTRODUCTION

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

Get Concepts of Database Management System now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.