What is RDBMS
Please visit SQLVERSITY.COM for more details.
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,
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.