Question

Suppose that all the customers of a particular business live in states for which city name is unique. Given the following description for customer data:
Cust-id, cust-name, street, city, state, phone
1. List the most likely key for the primary key.
2. List all the candidate keys and alternate keys

Answer 1

Answer:

1. cust-ID will most likely be the primary key.

2. city and phone no. will be candidate key & street, state, cust name will be an alternative key.

hope it helped.