Complete Computer Knowledge Portal

Sunday, June 1, 2014

Difference Between DBMS and RDBMS


Parameter
DBMS
RDBMS
Acronym for
Data Base Management System
Relational Data Base Management System
Relation
Data is stored in flat file oriented System and no relations are used.
It provides facility to create relation between tables.
Dr. E.F. Codd Rules
Only 3 rules, Out of 12, are followed by DBMS. (from Rule 0 to Rule 12)
Minimum 6 rules, Out of 12, are followed by RDBS. (from Rule 0 to Rule 12)
Data Security
It can’t implement constraints in Tables and has less Security. The ACID (Atomicity, Consistency, Isolation and Durability) property of the database is ensured by Programmer.
It can implement the integrity constraint for the purpose of holding ACID (Atomicity, Consistency, Isolation and Durability) property of the database and is much securing than DBMS.
Generation
3GL
4GL

Users Supported
Single User database, Microsoft Access, Lotus Approach are the best examples of personal database management software.
Multi User Database. E.g. SQL Server can be used my many users on the same time.
Normalization
Not Supported in DBMS.
It Supports Database Normalization
Area of Uses
It is generally suited for small scale projects and single user applications.
It is generally used in large scale projects and is well suited for multi user applications.
Examples
FoxBASE, FoxPro, Dbase
Oracle, Access, SQL Server, DB2.