Q1. Explain the relationship between two tables through an example.
Ans. The Employees_Details table contains the following fields:
The Department table contains the following fields:
The relationship between these two tables is created on the basis of a common field named E_Code. A relationship between these tables is established to fetch any information from both the tables. Further, establishing a relationship among tables allows you to link them to get meaningful information.