数据库系统基础教程第四章答案.docx

精品学习资料 名师归纳总结——欢迎下载 数据库系统基础教程第四章答案Solutions Chapter 44，1 数据库系统基础教程第四章答案 Solutions Chapter 4 4，1 ， 1 4，1 ， 2 a) b) c) In c we assume that a phone and address can only belong to a single customer (1- ， m relationship represented by arrow into customer) 第 1 页，共 35 页 精品学习资料 名师归纳总结——欢迎下载 数据库系统基础教程第四章答案d)In d we assume that an address can only belong to one customer and a phone can，exist at only one addressIf the multiplicity of above relationships were m-to-n, the entity set becomesweak and the key ssNo of customers will be needed as part of the composite key，of the entity 数据库系统基础教程第四章答案 d) In d we assume that an address can only belong to one customer and a phone can ， exist at only one address If the multiplicity of above relationships were m-to-n, the entity set becomes weak and the key ssNo of customers will be needed as part of the composite key ， of the entity set ， Since entity In c&d, we convert attributes phones and addresses to entity sets sets often become relations in relational design, we must consider more efficient alternatives ， Instead of querying multiple tables where key values are duplicated, we can also modify attributes: Phones attribute can be converted into HomePhone, OfficePhone and CellPhone ， A multivalued attribute such as alias can be kept as an attribute where a ， e ， concatenate all values ， single column can be used in relational design i SQL allows a query "like '%Junius%'" to search the multiple values in a column alias ， 第 2 页，共 35 页 精品学习资料 名师归纳总结——欢迎下载 数据库系统基础教程第四章答案4，1 数据库系统基础教程第四章答案 4，1 ， 3 4，1 ， 4 a) 第 3 页，共 35 页 精品学习资料 名师归纳总结——欢迎下载 数据库系统基础教程第四章答案b)c)The relationship "played" between Teams and Players is similar to relationship， 数据库系统基础教程第四章答案 b) c) The relationship "played" between Teams and Players is similar to relationship ， "plays" between Teams and Players 4，1 ， 5 第 4 页，共 35 页 精品学习资料 名师归纳总结——欢迎下载 数据库系统基础教程第四章答案4，1 ， 6 The information about children can be ascertained from motherOf and， 数据库系统基础教程第四章答案 4，1 ， 6 The information a