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:
