This problem deals with functional dependencies (FD)

Exercise 3.1.1: Consider a relation about people in the United States, includ- ing their name, Social Security number, street address, city, state, ZIP code, area code, and phone number (7 digits). What FD's would you expect to hold? What are the keys for the relation? To answer this question, you need to know something about the way these numbers are assigned. For instance, can an area Exercise 3.1.1: Consider a relation about people in the United States, includ- ing their name, Social Security number, street address, city, state, ZIP code, area code, and phone number (7 digits). What FD's would you expect to hold? What are the keys for the relation? To answer this question, you need to know something about the way these numbers are assigned. For instance, can an area