Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between RDBMS and DBMS?
- 20 Answers
- 77799 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 is trigger and how to use it in sql?
Which is better join or inner query?
how would you get the current date in mysql? : Sql dba
What is latest version of sql?
who introduced sql?
How many unique keys can a table have?
What are different types of triggers?
what is the difference between cluster and non cluster index? : Sql dba
How do you optimize a query?
does sql support programming? : Sql dba
what is a primary key? : Sql dba
what are null values? : Sql dba
Explain exception handling in pl/sql?
How do you update a value in sql?
What are the three forms of normalization?
