RDBMS stands for Relational Database Management Systems. It is called Relational Data Base Management System (RDBMS) because it is based on relational model introduced by E.F. Codd. RDBMS store the data into the collection of tables, which is related by common fields between the columns of the table. It also provides relational operators to manipulate the data stored into the tables.

RDBMS is the basis for SQL, and for all modern database systems like MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access.

History of RDBMS

RDBMS is originally based on that E.F. Codd's relational model invention. During 1970 to 1972, E.F. Codd published a paper to propose the use of relational database model.

Basic Features of RDMS

• Relational database contains number of tables and each table has its own primary key.
• Data is represented in terms of rows (It is also known as tuple) in RDBMS.
• Due to a collection of organized set of tables, data can be accessed easily in RDBMS.
• Virtual tables are available for storing the insightful data
• Numerous users can access it together which is managed by a single user
• In order to exclusively find out the rows, the primary key is used

What is table?

The RDBMS database uses tables to stored data in database objects which are called as tables. A table is the most common and simplest form of data storage in a relational database.

Example of a STUDENT Record table

What is a field?

Every table is broken up into smaller entities of the table which contains specific information about every record in the table; it is called fields. The above table consist of ID, NAME, AGE, COURSE, and BRANCH.

What is a row or a record?

Row contains the specific information of each individual entry in the table. It is a horizontal entity in the table.

For Example in STUDENT Table:

What is a column?

A table that contains all information associated with a specific field in a table. And a column is a vertical entity in the table.

For Example:

What is a NULL value?

The NULL value of the table specifies that the field has been left blank during record creation. It is very important to understand that a NULL value is different than a zero value or a field that contains spaces.

The Main Principles Of The RDBMS Model

Entity integrity - The entity integrity says that in a database, all the data should be organized having a single key. The uniqueness of all the data is maintained by this principle.

Referential integrity - Referential integrity means that in the database all table values stay true for all foreign keys.