Relational Database Management System(RDBMS)

RDBMS is the abbreviation for “Relational Database Management System”. A relational database management system (RDBMS) is a database management system (DBMS) based on the relational model developed by Edgar F. Codd in the early 1970’s and it satisfy the codd 12 rules(more than 7-8).

Most of the databases like IBM’s DB2,Oracle, MySQL, and Microsoft Access etc use in today are based on his relational database model.

Relational Database Management System (RDBMS) consists of collection of releated data in a tabular form and schema.There are several fundamental definitions to consider when thinking about RDBMS.

Table: The Table is collection of related data entries and it consist of column and rows.

Field: Every table is broken up into smaller entities called field.

Records(Tuple/Row): A record also called a Row or Tuple of table. On other hand, A single entry in a table is called a Tuple or Record or Row.