数据库系统基础学习知识教学教育资料第四章规范标准答案.docVIP

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). 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. In cd, we convert attributes phones and addresses to entity sets. Since entity sets often become relations in relational desig