Muhammad Mustaqim
Reputation: 19
ERD: Can an Associative Entity have a relationship with a Weak Entity?
Entity A and Entity B are strong entities and they have their own identifiers. Their Many-to-Many relationship is resolved with Associative Entity C, which has its own Identifier. I am just wondering if Entity C can have another relationship with a Weak Entity D whose existence depended on the Associative Entity C identifier.
Upvotes: 1
Views: 1901
Answers (1)
Christian Vielma
Reputation: 16035
Yes it can. You can find this in Fundamentals of Database Systems chapter: "Entity Relationship Extended" (I have the Spanish version so I'm not really sure about the exact translation)
Best regards,
Upvotes: 1
Related Questions
- Weak entity in ER design
- Properties of Weak Entities
- Weak entity with 2 different owner entities
- What is the right way to use Associative Entity?
- Associative entities and the ER model
- Is it possible to relate two weak entities each other?
- Specialization of a Weak Entity in ER Diagram Modeling
- Defining weak relationship in Entity relationship model
- What could go wrong if one ignored weak entities during database modelling?
- Understanding Weak Entities and Weak Relationships