Explain relationship between two tables.

Q1. Explain the relationship between two tables through an example.

Ans. The Employees_Details table contains the following fields:


E_Code E_Name E_Address E_ContNo E_Grade E_Salary


The Department table contains the following fields:


D_ID D_Name E_Code E_Name Design S_Scale


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.

Leave a Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this: