What is the difference between RDBMS and DBMS?
- 20 Answers
- 71772 Views
- Practical Viva Questions, Sapient, Stag Computers, I also Faced
- E-Mail Answers
Answer Posted / sree
DBMS or RDBMS are the different datebases models evolved
one after one.
Any file in this universe majorly falls into the following
categories
i) Data in a text file or other files
(.txt, .doc, .pdf, .ini etc.,)
ii) Data in a table format (.xls, .csv., etc)
In the first category the data is in a file and hence we
say it is not organised and no point of relation with other
files.
In the second category the data is in a table format which
contains colums and rows and hence we say it is in a well
organised manner. This kind of well organised data
representation is the base for all the Databases we use
these days.
Both DBMS and RDBMS are used to represent data in table
format, but it deffers how we represent and how we inter
connect, whats the data capacity, ease, application,
effeciency based on necessity etc.,
For example,
1) One Small Finance Company in a village has 500 customer
and 1000 transactions in an year. At the end of the year
the business owner want to see all the transactions to
analyse his business development. Here based on the
necessity and requirement the owner can use a excel or any
other spreadsheet model which is nothing but DBMS, just
managing database
2) A big insuracne company (Like LIC, Metlife) with huge
data like 1 crore customers (Includes customer address,
phone no., Email, ID, Policy Information etc.,), 2 Crore
claims, etc., Here the Company owner cannont use an excel
and hence the era of DBMS later lead to the invention of
RDBMS (Like Oracle, Teradata, DB2 etc.,) where the data
would not in a single table/excel sheet but in a different
tables with inter relationship.
What kind of relationship exists between tables?
As per example 2, let me take assume the business owner had
many tables among which the following are two tables
i) Customer_Details (This table is with details of customer)
ii) Customer_Claims (This table is with details of the
claims)
Customer_Details is a driving table for Customer_Claims as
the ID is the key which would be common between both the
tables. without id we cannot identify a claim of a
particular customer, this is called as relationship between
oth the tables.
| Is This Answer Correct ? | 50 Yes | 6 No |
Post New Answer View All Answers
How do I find duplicates in two columns?
How to return an array from java to pl/sql?
What is implicit cursor in pl sql?
What is synchronized subquery?
What is sql table?
What are different types of indexes?
How many types of cursors supported in pl/sql?
Is oracel sql developer written in java?
What is the clause we need to add in function body to return variable?
How do I run a sql trace?
List out the acid properties and explain?
What is fmtonly in sql?
What are the benefits of pl sql?
Which is better trigger or stored procedure?
How do I audit the sql sent to the server?
