1. Consider the following scenario: A company has a number of customers who have addresses and phone numbers, and we ass
Posted: Thu Jul 14, 2022 2:27 pm
1. Consider the following scenario: A company has a number ofcustomers who have addresses and phone numbers, and we assume thatwhile there may be multiple customers with the same address, no twocustomers with the same name have the same address or the samephone number. Each customer has a customer id, which is unique tothat customer. Suppose that this information is stored as arelational database relation or table. Answer the following: a.What is the schema for this relation (the attributes or columns andtheir domains or types)? b. What are possible superkeys for thisrelation? c. Which of the superkeys identified above are thecandidate keys for the relation? d. What is the best choice fromthe candidate keys for the primary key of the relation?