Difference between DBMS and RDBMS-

DBMS-

A database management system is a collection of interrelated data and a set of programs to access those data. The collection of data, usually referred to as the database, contains information relevant to and enterprise.

The primary goal of a DBMS is to provide a way to store and retrieve database information that is both convenient and efficient. A database is a collection of related information stored, so that it is available to many users for different purpose. A DBMS is a software system that allow access to data contained in the database.

APPLICATIONS OF DBMS-

Some of the important application fields of DBMS are:

Banking- For maintaining customer information, accounts, loans and banking transactions.

Universities- For maintaining student records, course, registration and grades.

Railway Reservation- For checking the availability of reservation in different trains, tickets, etc.

Airlines- For reservation and schedule information.

Telecommunication- For keeping records of calls made, generating monthly bills etc.

Finance- For storing information about holidays, sales and purchase of financial instruments.

Sales- For customer, product and purchase information.

RDBMS-

RDBMS stands for Relational Database Management System. RDBMS is a database management system that is based on the relational model it stores data in the form of related tables. RDBMS are powerful because they require few assumptions about how data is related or how it will be extracted from the database.

RDBMS is a structure form in which we store data in the form of rows and columns. It can store the data only in a table form.

As a result, the same database can be viewed in many different ways.

An important feature of relational system is that a single database can be spread across several tables.

Today, popular commercial for large database include oracle, Microsoft SQL server, Sybase SQL server.

PROPERTIES OF RELATIONAL TABLES-

Values are atomic.
Column values are of the same kind.
Each row is unique.
The sequence of rows is insignificances.
Each column has a unique name.
The sequence of columns is insignificance.

Advantage of RDBMS-

1. Ease of use-

The revision of any information as tables consisting of rows and column is quite natural and therefore, evens first time user finds it attractive.

2. Flexibility-

Different tables from which information has to be linked and extracted can be easily manipulated by operators such a project and joint to give information in the form in which it is desired.

3. Precision-

The usage of relational algebra and relational calculus in the manipulation of the relations between the tables ensures that there is no ambiguity, which may otherwise arise in establishing the linkage in a complicated network type database.

4. Security-

Security control and authorization can also be implemented more easily by moving sensitive attributes in a given table into a separate relation with its own authorization controls. Enter if authorization requirement permits, a particular attribute could be joined back with others to enable full information retrieval.

5. Data independence-

Data independence is achieved more easily with organization structure used in a relational database then in the more complicated tree or network structure.

6. Data manipulation language-

The possibility of responding to ad-hoc query be means of a language based on relational algebra and relational calculus is easy in the relational database. For data organized in other structure the query language either becomes complex or extremely limited in its capabilities.