Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between RDBMS and DBMS?
- 20 Answers
- 77122 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
Explain the commit statement.
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
What is nosql example?
how can we know the number of days between two given dates using mysql? : Sql dba
Why is stored procedure faster than query?
Why do we use function in pl sql?
What is the best partition size for windows 10?
what is sql server agent? : Sql dba
Is microsoft sql free?
what is collation? : Sql dba
Name some usages of database trigger?
What pl/sql package consists of?
Why we use triggers in mysql?
How do you truncate?
Can we group by two columns in sql?
