Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between RDBMS and DBMS?
- 20 Answers
- 77867 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
What are keys in sql?
Explain the order of sql statement execution?
How many sql core licenses do I need?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
Which software is used for pl sql programming?
Explain raise_application_error.
What is full join?
How is a process of pl/sql compiled?
What is the difference between function and procedure in pl/sql?
What is the purpose of my sql?
Is it mandatory for the primary key to be given a value when a new record is inserted?
how would concatenate strings in mysql? : Sql dba
What is the process of copying data from table a to table b?
What is faster join or subquery?
What is input buffer in sql*plus?
