数据库系统基本教学教程第三章答案解析.pdfVIP

* * 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: IDx-position, y-position, z-position 感谢阅读 IDx-velocity, y-velocity, z-velocity 感谢阅读 x-position, y-position, z-positionID 感谢阅读 Possible keys: {ID} {x-position, y-position, z-position}感谢阅读 The reason why the positions would be a key is no two molecules can occupy the same point.精品文档放 心下载 Exercise 3.1.3a The superkeys are any subset that contains A . Thus, there are 2(n-1) such subsets, since 1 each of the n-1 attributes A2 through An may independently be chosen in or out.谢谢阅读 * * Exercise 3.1.3b The superkeys are any subset that contains A or A . There are 2(n-1) such subsets when 1 2 considering A and the n-1 attributes A through A . There are 2(n-2) such subsets when 1 2 n considering A and the n-2 attributes A through A . We do not count A in these subsets