Difference Between DBMS and RDBMS.

 

     Difference Between DBMS and RDBMS.

DBMS:

Database Management System.

DBMS applications store data as file.

Allows one user at a time.

Normalization is not present in DBMS.

Individual data access.

No relationship defined for the data.

Manages the data in a computer.

Cannot handle large amount of data.

DBMS does not support distributed database.

Example: XML

RDBMS:

Relational Database Management System.

RDBMS applications store data in a tabular form.

Allows more than one user at a time.

Normalization is present in RDBMS.

Easy to data access.

Defines relationship using foreign key .

Maintains he relationship of table in a database.

Can handle large amount of data.

RDBMS supports distributed database.

Example: MYSQL, SQL Server, Oracle.

SQL:

• The Structured Query Language (SQL) is the language of databases.
• All modern relational databases, including Access, FileMaker Pro, Microsoft SQL Server and Oracle use SQL as their basic building block.
• In fact, it’s often the only way that you can truly interact with the database itself.
• All of the fancy graphical user interfaces that provide data entry and manipulation functionality are nothing more than SQL translators.
• They take the actions you perform graphically and convert them to SQL commands understood by the database.
• SQL is Similar to English
• Fortunately, at its core, SQL is a simple language.
• It has a limited number of commands and those commands are very readable and are almost structured like English sentences.

Watch Video

----------------------------------------------------------------------

Follow Us :-

YouTube: