'Employee' with structure as ID, name, Address, Phone, Deptno
'Department' with structure as Deptno, Dname
_____ is used to represent the relationship between two relations Employee and Department.
The question asks about the specific database concept used to link two different tables, specifically the 'Employee' table and the 'Department' table. We are given the structures of these tables:
The common column, 'Deptno', present in both tables is the key to establishing a connection or relationship between an employee and their respective department.
Let's look at the different types of keys mentioned in the options to understand why one is correct:
In this scenario, the 'Deptno' column in the 'Employee' table points to the 'Deptno' in the 'Department' table. This is exactly the function of a Foreign Key. The 'Deptno' in the Employee table is referencing the primary key ('Deptno') of the Department table, thereby representing the relationship: each employee belongs to a specific department.
Therefore, the Foreign Key is used to represent the relationship between the Employee and Department relations.
| List-I (Relief Materials) | List-II (Color Code) |
| A. Shelter | I. Yellow |
| B. Clothes | II. Khaki |
| C. Food | III. Red |
| D. Medicine | IV. Brown |
Which of the following is NOT a state function or state variable in a thermodynamic system?