CODEWITHSUNDEEP
databasedatabase-designentity-relationshiperdconceptual
ITGirl
ITGirl

Reputation: 37

Chen ERD Relationship Attributes

chen database erd diagram

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

Upvotes: 0

Views: 573

Answers (1)

RBarryYoung
RBarryYoung

Reputation: 56725

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.

Upvotes: 1

Related Questions