Let's first understand what an RDBMS is
RDBMS enables you to create databases that can store related data. A database is a collection of information that stores data in database objects, called tables. A table is a collection of related data entries, which consists of columns and rows.
RDBMS enables you to create a link between these tables by establishing a relationship between them. This relational model helps in obtaining related information from multiple tables using SQL. You can see in Figure 11.1 that there are three tables, Employee_Master
, Department_Master
, and Emp_Dept
. All these tables are related with a key field that is called the primary key. In the following example, you can see how the Emp_Dept
table, which provides department detail for employees, is linked with the Employee_Master
and Department_Master
tables:
![](https://static.packt-cdn.com/products/9781787125629/graphics/ecd5805d-c49f-418c-b8bb-48e13adf8166.png)
Figure 11.1: Relation between tables in an RDBMS
In a nutshell, this is how RDBMS co-relates with data stored in tables.
What is SQL?
SQL is a standardized language to...