To determine which two tables can have a relationship, we need to look at the common fields in the tables created by Ruchi. Let's examine the structure of each table.
Table 1:
- Fields: Emp_no, Emp_name
Table 2:
- Fields: Designation, Department
Table 3:
- Fields: Emp_no, Contact_no
By analyzing the field names in each table, we can see that:
- Table 1 has the fields: Emp_no, Emp_name
- Table 2 has the fields: Designation, Department
- Table 3 has the fields: Emp_no, Contact_no
To create a relationship between two tables, there must be a common field that can link the records from one table to the records from another table.
Looking at the fields, we notice that:
- Emp_no is present in both Table 1 and Table 3.
Since Emp_no is a common field between Table 1 and Table 3, Ruchi can create a relationship between these two tables based on the Emp_no field.
This relationship allows for linking employee information (from Table 1) with their contact information (from Table 3) using the Emp_no as the connecting key, thus integrating data between these tables.
In conclusion:
Table 1 and Table 3 can have a relationship based on the Emp_no field.
