Suppose all customers of a particular business live in states for which the city name is unique. Given the following description for customer data:

CUST-ID, CUST-NAME, STREET, CITY, STATE, PHONE

(i) List the most likely key for the primary key.
(ii) List all the candidate keys and alternate keys.

(i) The most likely primary key is CUST-ID because it is a unique identifier assigned to each customer.

(ii) CUST-ID, CITY attributes can be considered as candidate keys as both are unique to each customer.

CITY can serve as an alternate key because all customers live in states where the city names are unique.