what is the difference between DBMS and RDBMS??
Answer Posted / umarali1981
DBMS:
1.Stands for DataBase Management System
2.In dbms no relationship concept
3.It supports Single User only
4.It treats Data as Files internally
5.It supports 3 rules of E.F.CODD out off 12 rules
6.It requires low Software and Hardware Requirements.
7.DBMS is used for simpler business applications
8.DBMS does not impose any constraints or security with
regard to data manipulation
9.In DBMS Normalization process will not be present
10.There is no enforcement to use foreign key concept
compulsorily in DBMS
11.FoxPro, IMS are Examples
RDBMS:
1.Stands for Relational DataBase Management System
2.It is used to establish the relationship concept between
two database objects, i.e, tables
3.It supports multiple users
4.It treats data as Tables internally
5.It supports minimum 6 rules of E.F.CODD
6.It requires High software and hardware requirements.
7.RDBMS is used for more complex applications.
8.RDBMS defines the integrity constraint for the purpose of
holding ACID PROPERTY
9.In RDBMS, normalization process will be present to check
the database table consistency
10.Although the foreign key concept is supported by both
DBMS and RDBMS but its only RDBMS that enforces the rules
11.SQL Server, Oracle are examples
Reference:
http://onlydifferencefaqs.blogspot.in/2012/07/sql-server-difference-faqs-5.html
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is data model and types?
Can anybody give me link for BOXI R3.1 Key please
Explain the term entity set in dbms?
What is a candidate key in dbms?
What is the biggest advantage of rdbms?
Define transaction and transaction isolation levels?
Difference between data and information, and how are they related in a database?
How do you maintain a database?
How to stop superserver service on linux using only firebird tools?
dear sir please provide what question will be asked in bank it officer interview
What is a key in database?
Where is the database stored?
What are fact tables and dimension tables ? What is dimensional modeling and star schema design
What is the difference between a catalog and a database?
Mention a query to add email validation to your database