Thursday, December 26, 2013

DBMS VS RDBMS

DBMS: Database Management Systems is a software (or set of programs) designed to create and maintain a database to store and retrieve information.

Data stored in single large tables and when modify or insert a record whole database is modified or updated.

RDBMS: Relational Database Management Systems is a DBMS that maintains the data in tables and relationships which are created and maintained across and among the data and tables. (developed by Dr.E.F Codd in 1970’s-80’s).

The database management system (DBMS) of a relational database is called an RDBMS, and is the software of a relational database.

Database is broken down in to multiple tables so when modify or insert a record only a small portion(table) of the database is modified or updated. Tables connected to maintain the relationships using “key fields(or Columns)”.

In Tables data is stored in Rows (Tuples) and Columns (Attributes).