Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between DBMS and RDBMS??
- 76 Answers
- 199634 Views
- Aon Hewitt, BlackRock, Infosys, ISB, Jawood, TCS, I also Faced
- E-Mail Answers
Answer Posted / divya
The difference is dbms has no tables ,while rdbms has and
also it describes about the relationships among the tables.
The difference between dbms and rdbms is that it doesn't
show the relation while rdbms show the relation and moreover
dbms is for small organisations where rdbms for large amount
of data In DBMS all the tables are treated as different
entities.
There is no relation established among these entities. But
the tables in RDBMS are dependent and the user can establish
various integrity constraints on these tables so that the
ultimate data used by the user remains correct.
In DBMS there are entity sets in the form of tables but
relationship among them is not defined while in RDBMS in
each entity is well defined with a relationship set so as
retreive our data fast and easy.
The main advantage of an RDBMS is that it checks for
referential integrity (relationship between related records
using Foreign Keys). You can set the constraints in an RDMBS
such that when a paricular record is changed, related
records are updated/deleted automatically.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are different cursor types in dbms?
What is the difference between a delete command and truncate command?
Explain a checkpoint and when does it occur?
What are the limitations of database?
What are the two types of database?
What are the two types of data independence?
What is database Configuration assistant ?
With DTS packaging I can store tables in Excel and convert them back to SQL. But once I copied tables to Excel I want to modify some info. How you do that without editing the Excel file?
What do you understand by sub-queries in sql?
Explain issues for database performance.
How to improve query performance using index hunting?
When should you consider denormalization?
Explain about the case statement present in stored procedure?
Define database system.
What is field record and table in database?
