When an Entity relates to another entity by relationship(n - n). For example, an Entity "A" has many Entities "B", and an Entity "B" has many Entities "A", so this relationship creates an Entity "C" between them. Besides, Entity "C" may have some properties.
My question is that can Entity "C" play as primary key or foreign key for another Entity.
Please help me soon and send to my email address: ngtthong@yahoo.com
I think you can. It might be a very complex relation you are trying to build. Can you please mail the relations? If I see what you are doing it might help understand better.
If the many-to-many relationship between A and B has some fixed attributes and some time-related attributes, you could imagine that you could put in entity C the fixed attributes and create an entity D containing the time-related values, the identifier of D being the relationshipe with entity C and from/to dates for instance.
Previous Topic
