1. Consider the following scenario: a photography store has a number of customers who have names, addresses and phone numbers and we assume that while there may be multiple members with the same address, no two members with the same name have the same address and no two members with the same name have the same phone number. Each customer has a customer number, which is unique to that customer. Suppose that this information is stored as a relational database relation or table. Answer the following:

a. What is the schema for this relation (the attributes or columns and their domains or types)?

b. What are possible superkeys for this relation?

c. What are the candidate keys?

d. What is the best choice for primary key?