In the figure below, Customer_ID in the CUSTOMER Table is which type of key?
A) Composite
B) Candidate
C) Standard
D) Grouped

Question

In the figure below, Customer_ID in the CUSTOMER Table is which type of key? 
A) Composite 
B) Candidate 
C) Standard 
D) Grouped

Quizplus · Accepted Answer

Customer_ID in the CUSTOMER Table is a Candidate Key. A candidate key is a column or a set of columns in a table that can uniquely identify any database record without referring to any other data. In this case, Customer_ID is unique for each customer and can be used as a primary key for the table. A composite key is a combination of two or more columns that together can uniquely identify a record. A standard key and grouped key are not commonly used terms in database design.

In the Figure Below, Customer_ID in the CUSTOMER Table Is