Question

given a relation teacher subject (tcode,scode,standard) which of the following fields can be an appropriate foreign key field?(a)Tcode(b)Scode(c)Tcode,standard(d)Tcode,Scode

Answer 1

Tcode,Scode are the appropriate foreign key field in a relation teacher subject

Explanation:

• A FOREIGN KEY is a field (or field collection) in one table which corresponds to the PRIMARY KEY in a different table.
• In the above-said scenario given there will be a teacher, subject and teacher-subject tables in DBMS. In the teacher-subject table as given the Tcode (Teacher Code which is the primary key in Teacher table) & Scode (Subject code which is in primary key in the Subject table) can be an appropriate foreign key.

Answer 2

Answer:

ans is option d is the ans