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

Explain two easy sql optimizations.

0 Answers  

Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get the name and SID of the student who are taking course = 3 and at freshman level.

9 Answers   Oracle,

How does sql developer connect to oracle database?

0 Answers  

i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?

4 Answers   Tech Mahindra,

SELECT flavor, SUM (ice_cream_sales) FROM sales_detail GROUP BY flavor ORDER BY 2 DESC If the "sales_detail" table contains ten records with different values in the flavor column (two "vanilla," three "chocolate," four "strawberry," and one NULL), how many rows are returned by the sample code above? 1. 0 rows 2. 1 row 3. 3 rows 4. 4 rows 5. 10 rows

8 Answers   Sonata,

How do I order columns in sql?

0 Answers  

How to display Row Number with Records in Oracle SQL Plus?

0 Answers   MCN Solutions,

Explain table and field in sql?

0 Answers  

in procedure how to return a value

3 Answers   Wipro,

how will be date change into string

4 Answers  

Which sql statement is used to return only different values?

0 Answers  

What is the difference between drop and truncate commands?

0 Answers