Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> Database Management
  2. Suggest New Category

what is the difference between DBMS and RDBMS??

Question Posted / umarali1981

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


Please Help Members By Posting Answers For Below Questions

What is 'cross join'? Or what is cartesian product?

824

What is Normalization and its different forms?

953

Explain the types of database normalization?

873

Mention some advantages of using dbms.

881

What is type of end users?

751

Explain the functionality of dml compiler.

938

How to repair a corrupt firebird database?

994

Why c++ used in clipper?

870

what do u mean by implementation?

2074

Is it possible to determine clients ip address?

869

What is the meaning of flat file database?

941

What are the types of database users?

937

How to find the size of database?

977

Explain the importance of database partitioning.

886

What is unique key in dbms?

860