Question

i) Stud_Addr (R_No, Name, Address, Place, Pin)
ii) Stud_Marks(R_No, Subject, Exam_date, Marks).
Draw and explain parent child relationship for above schemas and Find out Foreign Key with justification.

Answer 1

Here in STUD_ADDRESS table R_NO is the primary key because every student has a unique register no.
In STUD_MARK table we have R_NO which is already present in above table so it will inherit the information from STUDENT _ADDRESS table hence R_NO in STUD_MARK table is considered as foreign key