Which of the following statements is true regarding a composite key in a table?
A.
It is a primary key.
B.
It is a primary or foreign key that consists of two or more attributes of the table.
C.
It is a combination of the primary key and the foreign key.
D.
It is a foreign key.
Explanation:
A composite key is a primary or foreign key that consists of two or more attributes of the table. It is a
key that consists of two or more
attributes that uniquely identify an entity occurrence.
Answer C, D, and A are incorrect. These statements do represent a composite key.
A composite foreign key is a foreign key that consists of two or more columns.
In database design, a compound key is a key that consists of two or more simple keys that uniquely identify an entity occurrence. A simple key is one that has only one attribute. Compound keys may be composed of other unique simple keys, but may not include another compound key.