edited by
3,506 views
1 votes
1 votes

Which of the following key constraints is required for functioning of foreign key in the context relational databases?

  1. Unique key
  2. Primary key
  3. Candidate key
  4. Check key
edited by

2 Answers

0 votes
0 votes

Answer can be 3 candidate key according to Wikipedia

A foreign key is a set of attributes that references a candidate key.

 

Foreign key 
If an attribute can only take the values which are present as values of some other attribute, it will be foreign key to the attribute to which it refers. The relation which is being referenced is called referenced relation and corresponding attribute is called referenced attribute and the relation which refers to referenced relation is called referencing relation and corresponding attribute is called referencing attribute.

https://en.m.wikipedia.org/wiki/Foreign_key

But according to reference books Korth, Raghu ramkrishan

Answer must be B primary key because candidate key can be NULL such case reference can be break but primary key always unique and not null. It should be appropriate and right option.

edited by
0 votes
0 votes

 The referential integrity property states that

When a foreign key value is used it must reference a valid, existing primary key in the parent table.

$\therefore$ Option $B.$ is correct.

edited by
Answer:

Related questions

2 votes
2 votes
1 answer
1
Arjun asked Jul 2, 2019
2,504 views
In relational database management, which of the following is/are property/properties of candidate key?P: UniquenessQ: IrreducibilityP onlyQ onlyBoth P and QNeither P nor ...
3 votes
3 votes
2 answers
3
Arjun asked Jul 2, 2019
4,090 views
Which of the following features is supported in the rational database model?Complex data-typesMultivalued attributesAssociations with multiplicitiesGeneralization relatio...
3 votes
3 votes
3 answers
4
Arjun asked Jul 2, 2019
2,970 views
With respect to relational algebra, which of the following operations are included from mathematical set theory?JoinIntersectionCartisian productProjecti and ivii and iii...