Consider the following example.
Example:
A University name BITS has maintained the two relations to store the information about the faculty table and Teaches table. The faculty table stores the faculty_id (faculty_id has the unique id of faculty in the whole university) and faculty_name. The Teaches table stores the Course_id, Course_Name, and faculty_id. So the university admin department prints the faculty_name and Course_Name.
The attribute faculty_id acts like which key in Teaches table?
1
Primary key
2
Candidate Key
3
Foregin Key
4
Super key
5
Question Not Attempted