Answer / samas

DBMS: 
      Logical view and physical view is considered.
      Foreign key though support does not provide relation.
      Manage the database.
RDBMS: 
       Logical view is considered.
       Relation ships is provided by it.
       relationships among the data is managed.

Answer / h.r.nayak

DBMS:data base management system
RDBMS:relational data base management system
>dbms does not support normalisation when rdbms support
normalisation

Answer / pravin wankhade

1)Relational Data Base Management System manage the Relation
in Between the Two Tables(i.e rows & column)And Data Base
Management System Manage the data base
2)Multiple user can Access those data they want in RDBMS but
in DBMS single user can access data in to the data base
3)In DBMS we can not create the Relation but we create the
Relation in RDBMS
4)DBMS manage the Relation in Between the single table
Attributes,Relational Data Base Management We require two Or
More tables to maintain the relations in between Attributes
5)In DBMS we can Manage the Data base by Create Table, While
in RDBMS we can maintain the relations In Between The Tables

Answer / dhruv patel

1>Database Management System is About Managing and structuring the collections of data held on computers. A database consists of an organized collection of data for one or more uses, typically in digital form. Database involves the type of their contents.

Eg:- bibliographic, document - text, statistical.

RDBMS stands for Relational Database Management System. RDBMS data is structured in database tables, fields and records. Each RDBMS table consists of database table rows. Each database table row consists of one or more database table fields.

Answer / ashish sharma

Difference between DBMS and RDBMS--

DBMS i.e. DataBase Management System is a collection of
Data in a file which is not organised and related in any
case..Its just a file in which resords has been inserted
for further uses and that caould be any format...As compare
to it RDBMS is a DBMS that is related and organised
collection of data..By organised we mean that it is in a
particular and in pre defined format and relational means
that each data is related to each other in some order.


RDBMS supports tables..A Table is a something which has
Rows and Columns.Table contains Field and Fields contains
Records.Row of Table is also called "TUPLES" sometimes and
columns are called Attributes..

RDBMS also supports relationship between 2 tables i.e.
PRIMARY and FOREIGN key relationship..

RDBMS also provide DML,DDL and DCL for entering data and
manipulating it at column and table level...

RDBMS also supports CHECK constraints before entering any
data in the table and it also provides validations like NOT
NULL and UNIQUENESS....

SQL has been written to support RDBMS and it dos not
support DBMS...

RDBMS supports multiple users to access the same data at
the same time but DBMS supports single user to allow
accessing the data at a particular point of time...

There is one more concept of Codd's Rules..Professor
E.F.Codd has given its 12 rules..Hence any DBMS that
supports these Codd's rules becomes an RDBMS..

RDBMS also supports Data Normailization while a DBMS not.

There is one for fact that no RDBMS supports and follows
all 12 Codd Rules...

DBMS does not supports Client/Server Architechture while
most of the RDBMS supports Client/Server Architechture...

DBMS does not support Distributed databases but most of the
RDBMS supports...


RDBMS examples-Oracle,My SQL,SQl Server,MS-Access,Sybase,
Ingrase etc.

DBMS examples-Visual Foxpro etc.

Answer / a.satheesh

1)DBMS permits only one person to access the database at a
given time.
2)But RDBMS gives the multiple access the database
at a given time.

DBMS - DataBase Managemnt System
RDBMS - Relational DataBase Managemnt System

Answer / madhu

DBMS stands for database management system.It is based on
different types of model like network,relation,object etc..
RDBMS is nothing but DBMS is based on the concepts of
relation.
RDBMS is a tabular representation of data.It satisfies
Codd's rules and some constraints.

Answer / roshie

1 relation between two or more files or table maintain regularly in case of DBMS
while in case of RDBMS relationship is specified on the time of table creation
2 DBMS doesn't support client/server architecture
RDBMS supports the client/server architecture
3 loose security
we have 3 steps of security.

Answer / saurav majumder

DBMS creates Data and Meta Data
RDBMS creates relations between tables and rows.

Answer / sreenivas

THE MAIN DIFFERENCE BETWEEN DBMS and RDBMS IS THAT:
DBMS STANDS FOR DATA BASE MANAGEMENT SYSTEM and
RDBMS STANDS FOR RELATIONAL DATA BASE MANAGEMENT SYSTEM..
AND, DBMS CAN CREATES DATA, STORED DATA AND META DATA...
AND, RDBMS CAN CREATES RELATIONS BETWEEN TWO TABLES, ROWS
AND COLUMS OR TOUPLES.....

How delete all data from all tables in sql?

0 Answers  

Can we use joins in subquery?

0 Answers  

Is coalesce faster than isnull?

0 Answers  

How do you delete a table?

0 Answers  

What is the difference between an inner join and an outer join?

0 Answers  

How do you write a complex sql query?

0 Answers  

Which sorts rows in sql?

0 Answers  

How can you load microsoft excel data into oracle? : aql loader

0 Answers  

what is External tables? explain with examples

2 Answers   TCS,

what is an extent ? : Sql dba

0 Answers  

Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance

5 Answers   Target,

Explain cursor types?

0 Answers