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 *

5 Views
%d bloggers like this: