Consider the two relations below. The primary keys are underlined. Identify all possible foreign key(s) from the options based only on the two relations.

EMP (eid, ename, did)

DEPT (did, dname)

This question was previously asked in
UGC NET Computer Science (Paper 2) 11 March 2023 Official Paper
View all UGC NET Papers >
  1. eid
  2. did
  3. eid, did
  4. eid, did, ename

Answer (Detailed Solution Below)

Option 2 : did
Free
UGC NET Paper 1: Held on 21st August 2024 Shift 1
10.9 K Users
50 Questions 100 Marks 60 Mins

Detailed Solution

Download Solution PDF

The correct answer is did

Key Points

  • Foreign Key: A foreign key in a database is a field or collection of fields in one table, that is a primary key in another, related table. The purpose of the foreign key is to ensure referential integrity of the data.
  • In the relation provided, 'did' in the EMP relation can be a foreign key that refers to the 'did' in the DEPT relation. The column 'did' in the EMP relation identifies the department to which an employee belongs, and it's reasonable to think that each 'did' in EMP corresponds to a 'did' in DEPT.

Additional Information

  • Primary Key: The primary key is a distinct type of candidate key chosen by the database designer to make a row unique in a table. It can neither have null values nor duplicate values.
  • Super Key: A super key is a set, or any subset of, one or more columns (attributes) that can be used to uniquely identify a record in a database table. It can include extraneous attributes.
  • Candidate Key: A candidate key is a minimal set of columns (that is, a super key reduced to its irreducible minimum) which can uniquely identify a record. There can be more than one candidate key, but they each must be able to uniquely identify a record without any extraneous data.
Latest UGC NET Updates

Last updated on Jun 6, 2025

-> The UGC NET Exam Schedule 2025 for June has been released on its official website.

-> The UGC NET Application Correction Window 2025 is available from 14th May to 15th May 2025.

-> The UGC NET 2025 online application form submission closed on 12th May 2025.

-> The June 2025 Exam will be conducted from 21st June to 30th June 2025

-> The UGC-NET exam takes place for 85 subjects, to determine the eligibility for 'Junior Research Fellowship’ and ‘Assistant Professor’ posts, as well as for PhD. admissions.

-> The exam is conducted bi-annually - in June and December cycles.

-> The exam comprises two papers - Paper I and Paper II. Paper I consists of 50 questions and Paper II consists of 100 questions. 

-> The candidates who are preparing for the exam can check the UGC NET Previous Year Papers and UGC NET Test Series to boost their preparations.

Get Free Access Now
Hot Links: online teen patti teen patti bodhi teen patti list teen patti real cash game teen patti bindaas