DB Concept": Identifying and Non-Identifying Relationships

最新推荐文章于 2020-09-05 10:39:59 发布

yexianyi

最新推荐文章于 2020-09-05 10:39:59 发布

阅读量910

点赞数

分类专栏： Database 文章标签： attributes

Database 专栏收录该内容

36 篇文章

订阅专栏

本文解析了四种关系类型：标识关系、非标识的可选关系、非标识的强制关系及非特定关系，并探讨了它们如何影响数据模型的设计。文章还讨论了各种关系类型的基数形式及其在生成物理模型时对ForeignKey列的影响。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

• Relationship Type > Identifying Relatio nships: Identifying relationships are always mandatory. A foreign key value must exist in the child entity and the foreign key value must be found in the primary key of the parent. Identifying relationships propagate primary keys as primary keys to child entities, which can result in compound keys.
The use of compound keys is often valid and appropriate; however, they limit the flexibility of your data model. When you use a compound key, the data contained in the child entity can only be identified in the context of its parent. If you ever need to use the data independently, then you will have a problem.
The cardinality of a mandatory relationship must be in the form of one-to-something.
When generating a physical model, foreign key columns propagated by a mandatory relationship default to NOT NULL.

• Relationship Type > Non-Identifying, Optional Relationships:Non-identifying relationships propagate the parent's primary key to the non-key attributes of the child. Since the relationship is optional the foreign key value is not always required in the child entity; however, if a value does exist, then the foreign key value must be found in the primary key of the parent.
The cardinality of an optional relationship takes the form of zero or one to something.
When generating a physical model, foreign key columns propagated by a optional relationship default to NOT NULL.

• Relationship Type > Non-Identifying, Mandatory Relationships:Non-identifying relationships propagate the parent's primary key to the non-key attributes of the child. A foreign key value must exist in the child entity and the foreign key value must be found in the primary key of the parent.
The cardinality of a mandatory relationship must be in the form of one to something.
When generating a physical model, foreign key columns propagated by a mandatory relationship default to NOT NULL.

• Relationship Type > Non-Specific Relationships:Non-specific relationships denote many-to-many relationships. Because many-to-many relationships cannot be resolved, non-specific relationships do not propagate any foreign keys. Many-to-many relationships are undesirable and should be removed as you normalize your data model.
The following illustrates a non-specific relationship where the parent and the child are both optional. In the Relationship Editor you can specify whether the parent and the child are optional or mandatory.