Note-This article is in progress

Table of Content-

  1. What is database or database management systems (DBMS)?
  2. What are examples of DBMS?
  3. What is difference between DBMS and RDBMS?

 

What is database or database management systems (DBMS)?

DBMS (Database Management System ) is a software program (‘'s) designed to define, manipulate, retrieve and manage data in a database.

 

What are examples of DBMS?

MySQL, PostgreSQL, Microsoft Access, SQL Server, FileMaker, Oracle, RDBMS, dBase, Clipper, and FoxPro

What is difference between DBMS and RDBMS?

DBMS – Data Base Management System

RDBMS – Relational Data Base Management System or Relational DBMS

DBMS has to be persistent, does not impose any constraints or security with regard to data manipulation. In DBMS  it is programmer responsibility to ensure the ACID PROPERTY

DBMS Examples– File System, XML

RDBMS adds the additional condition that the  system supports a tabular structure of the data, with enforced relationships between the tables. RDBMS defines the integrity constraint for the purpose of holding ACID PROPERTY.

RDBMS Examples– SQL Server, Oracle.