What is the difference between RDBMS and DBMS?
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
Does a user_objects view have an entry for a trigger?
How do I write a sql query in pgadmin 4?
How many postgresql users are there, worldwide?
How do you identify a primary key?
what is msql? : Sql dba
Explain character-manipulation functions?
Is natural join and inner join same?
What are inbuilt functions in sql?
what are local and global variables and their differences? : Sql dba
What is snowflake sql?
what are aggregate and scalar functions? : Sql dba
How can I see all tables in sql?
How do I partition in sql?
Is left join same as inner join?
What is the sql case statement?