Difference between DBMS and RDBMS

RDBMS is a super set of DBMS plus some more features.

Consolidated few differences here.


DBMS RDBMS
Organization, storage, management, and retrieval of data Yes Yes
Flat file design Yes No
Relational design No Yes
Password protection Yes Yes
Enforce referential integrity No Yes
Null or blank data management Yes Yes
Meta data support Yes Yes
Support relatively large set of data No Yes
Support complex business applications No Yes

Microsoft Access is an example of  DBMS.

Oracle, Microsoft SQL Server, DB2 are few examples for RDBMS.

Advertisements

Author: sqlandplsql

To learn more about the Oracle, SQL, PL SQL, Performance Tuning, Database Modeling, Ubuntu, MySQL etc .Suggestions, comments, feedbacks and referrals are highly appreciated.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s