Computer Science
An attribute in a relation is a foreign key if it is the …………… key in any other relation.
- Candidate
- Primary
- Super
- Sub
Relational Database
1 Like
Answer
Primary
Reason — A non-key attribute, whose values are derived from the primary key of some other table, is known as foreign key in its current table.
Answered By
2 Likes
Related Questions
A …………… is a property of the entire relation, which ensures through its value that each tuple is unique in a relation.
- Rows
- Key
- Attribute
- Fields
Which of the following attributes cannot be considered as a choice for primary key ?
- Id
- License number
- Dept_id
- Street
Consider the table with structure as :
Student(ID, name, dept name, tot_cred)In the above table, which attribute will form the primary key ?
- Name
- Dept
- Total_credits
- ID
Which of the following is not a legal sub-language of SQL ?
- DDL
- QAL
- DML
- TCL