It exhibits all relationships. It is very easy to manage the data.
In RDBMS data is stored in tabular form.
Tables have rows & columns.
Rows represent records and column represents fields.
To access the data in RDBMS “SQL (Structured Query Language)” is used.
Limitations of RDBMS:
1. It is slow as compare to network RDBMS.
2. Redundancy of data to establish the relationship between tables.
Different types of RDBMS:
ORACLE, SQL Server, Sybase, DB2, MySQL, etc.
SQL queries are divided into three parts:
1. DDL: create, alter, rename, etc.
2. DML: insert, update, delete, truncate, etc.
3. Data retrieval: Select Queries.