Home » Tutorials » Relational DBMS (RDBMS)

Relational DBMS (RDBMS)

Our Categories

Blog Stats

  • 33,751 hits

Calendar

March 2013
M T W T F S S
« Feb   Apr »
 123
45678910
11121314151617
18192021222324
25262728293031

What is RDBMS

Please visit SQLVERSITY.COM for more details.

A Database Management System is said to be Relational if it works based on Relational model. This was introduced by E.F.Codd in 1969.

A relational database is a collection of data organized and described in terms of related tables from which data can be accessed easily. A relational database is created using the relational model.

In the relational model entire data is represented in terms of rows(tuples) which are grouped into relations. A relation among the data is usually described as a table, which is organized into rows and columns. While discussing about RDBMS, some folks might use some terminology like Tuple and Attribute. Actually Tuple means a row and Attribute means a column. As of now almost all the popular databases are based on Relational model only. Most of the Relational Database Management Systems use the Structured Query Language(SQL) to access the data from database. Since Relational databases are easier to understand, It replaced  hierarchical databases and network databases even though they are less efficient.

The most popular RDBMS are Oracle, SQL Server, DB2, Sybase etc…

The vendors of the five leading RDBMS are,

what is database management system
I do not know why, if someone wants to give an example on database, 95% of the people choose Employee and Department tables. So let’s follow the same trend as everyone 🙂

Example:

RDBMS

In the above example, both the tables have a common column called DepartmentID. So we can say that, these two tables are related based on DepartmentID column.

By joining these two tables based on DepartmentID, we can retrieve the required data. We will discuss about joins in the upcoming tutorials.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: