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.
|
