数据库系统基础教程第三章-答案.docVIP

—— — Exercise 3.1.1 Answers for this exercise may vary because of different interpretations. Some possible FDs: Social Security number ? name Area code ? state Street address, city, state ? zipcode Possible keys: {Social Security number, street address, city, state, area code, phone number} Need street address, city, state to uniquely determine location. A person could have multiple addresses. The same is true for phones. These days, a person could have a landline and a cellular phone Exercise 3.1.2 Answers for this exercise may vary because of different interpretations Some possible FDs: