Which of the following descriptions about foreign key are not correct?
(A) Foreign key must refer to the primary key of other relation.
(B) Foreign key is not necessary a primary key in its own relation.
(C) Foreign key must have the same name as the primary key it refers to.
(D) Foreign key cannot have null value.