Introduction to RDBMS

Introduction

Data is meaningful information.
Database is a collection of relevant data.
DBMS means database management system.
DBMS provides the software to manage the database.
Following are the operations to be performed on database: insertion, deletion,
updation, sorting, searching, traversing, etc.

Following are the different types of DBMS:

FMS, Hierarchical, DBMS

FMS (File Management System)

It is simple to create but difficult to manage.
No relations are there (like 1-to-1, 1-to-many)

Hierarchical System

Here data is stored in tree like structure.
It exhibits / exists 1-to-many relationship only.

Network DBMS

It exhibits all relationships. It is quite fast to manage the data.
Limitation: As size increases, it becomes very complicated to manage.