'Chen ERD Relationship Attributes
This is a portion of a Gaming Company Chen diagram that I need to convert to a database. How do I know which entity will get the attributes LastPlayed and CreatedOn? I feel like I could make a case for either entity. It could be the LastPlayed and Created on of the Account or the Character. Is there a rule for this? TIA
Solution 1:[1]
The attributes you show belong to the relationship, and not either of the entities. In this case, practically speaking implementation would make them part of the (N) side of the relationship, that is, the Character entity.
The distinction between entity-attributes and relation-attributes only really matters for many-to-many relations that have to be implemented by converting the relation into its own table.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | RBarryYoung |