In a non-identifying relationship在非标识关系中:()?
(A)The primary key of the parent entity becomes a foreign key in the child entity父实体的主键,成为子实体的外键
(B)The primary key of the child entity is removed子实体的主键被移除
(C)The primary key of the parent entity becomes part of the primary key of the child entity父实体的主键,成为子实体主键的一部分
(D)The primary key of the child entity is concatenated子实体的主键是连接的
(E)The foreign key of the parent entity migrates to the child entity父实体的外键转移到子实体 答案解析: 这里有两个概念,非标识关系,标识关系,这里先作概述,详细的请等待视频对建模做完整性介绍标非识关系:一般用于联合主键才能标识实体记录的唯一性标识关系:不需要联合主键,也能标识实体记录的唯一性,本文048题,就是标识关系 其实现在的数据库设计中,特别是计算机硬件便宜了之后,几乎见不到联合主键的情况,用联合主键只是为了节省一个代理键(surrogate keys,自增长ID或GUID等,ID无意义,只是作为唯一标识,所以才叫代理键)字段的存储空间,没有这个必要性 这一题的答案跟48题是一样的,只是换了一表述,请本试卷参阅48题也就父实体与子实体是一对多的关系(一个老爸有多个儿子),主外键请参照其它题目


更多CDMP数据治理试题
- 1The star schema is星型模式是:()?
- 2Master Data Management encompasses all these activities EXCEPT主数据管理包括所有这些活动,除了:()?
- 3A Data Quality dimension is:数据质量维度是::()?
- 4According to the ISO/IEC 42010:2007 Software and Systems Engineering-Architecture Description, which of the following describes the definition of architecture:根据ISO/IEC 42010:2007软件和系统工程-体系结构描述,以下哪一项描述了体系结构的定义::()?
- 5In a data warehouse, where the classification lists for organization type are inconsistent in different source systems there is an indication that there is a lack of focus on在数据仓库中,组织类型的分类列表在不同的源系统中不一致,这表明缺乏对:()?
- 6Who writes the data governance policy?谁编写数据治理策略?:()?