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.
|
No comments:
Post a Comment