An RDBMS enables you to create databases that can store related data. A database is a collection of information that stores data in tables. A table is a collection of related data entries consisting of columns and rows.
An 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 the following diagram 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 details for employees, is linked to the Employee_Master and Department_Master tables:
In a nutshell, this is how an RDBMS stores...
