RDBMS stands for Relational Database Management Systems. An RDBMS is a Database Management System (DBMS) which is designed specifically for relational databases. Therefore, RDBMS’s works as a subset of DBMS’s.
A Relational Database means a database which stores data in a structured form, i.e. by using the form of rows and columns. The arrangement of data makes easy to find and access specific data values within a database. It is said as "relational" because all the values in each table are related to each other. However, Tables are also related to other tables of the database. The relational structure of the database makes it successful to run queries across multiple tables at one time.
Mostly modern RDBMSs provide the accessibility to create a relationship either programmatically, or through a graphical user interface (GUI)
. The GUI method, allow to see the relationship among the tables and represented all in a visual diagrammatic form
. One of the basic function of RDBMS are related to create, read, update and delete query operations, and collectively it is known as CRUD
. The RDBMS usually provides a data dictionary and a collection of metadata
which are very useful in the handling of data. This programmatically defined support is a well-defined form of data structures
and relationship establishment. One of the most common methods of accessing data for the RDBMS is through SQL
. Its main language components consist of Data Manipulation Language (DML) and Data Definition Language (DDL) statements.
A relational database has the following major components:
- Record or Tuple
- Field or Column name or Attribute