FOREIGN KEY:

• Foreign Key is a column or a combination of columns whose values match a Primary Key in a different table.
• It acts as a cross-reference between tables because it references the primary key of another table, thereby establishing a link between them.
• For example, a table called Player …

Foreign Key:

• Primary key of one relation is used as an attribute in another relation is called as foreign key.

• It is a part of referential integrity where one relation is referenced in another relation.

• Consider two relations as:

emp(empNo, EN, FN, email)

Dept(DeptNo, Name, Location)

• To establish a relation …