Entity relationship diagrams doubt

Join the discussion
Ask a follow-up here, or get your own question answered by working scientists, mathematicians and engineers — people, not an autocomplete.
Real named experts · corrections over time · the nuance an AI answer skips
2 replies · 3K views
colt
Messages
20
Reaction score
0
I am doing a project of an entity relationship model and a doubt came: Should repeated attributes of the entities be shared? Or I must reproduce these to every entity? In another words, if two of my entities are books and magazines, shall I have a single publisher attribute, or one for each?
 
Physics news on Phys.org
colt said:
I am doing a project of an entity relationship model and a doubt came: Should repeated attributes of the entities be shared? Or I must reproduce these to every entity? In another words, if two of my entities are books and magazines, shall I have a single publisher attribute, or one for each?
What if you have some other entity, such as publication, with books and magazines as subclasses (or subentities)?

Whatever attributes that both books and magazines have in common could be defined in the publication entity, and the attributes that books and magazines don't share would go in one or the other of these entities.

That's just my take...
 
Mark44 said:
What if you have some other entity, such as publication, with books and magazines as subclasses (or subentities)?

Whatever attributes that both books and magazines have in common could be defined in the publication entity, and the attributes that books and magazines don't share would go in one or the other of these entities.

That's just my take...

True, that's a better solution. On a side note, anyone here has any experience using yuml? If someone does, the problem is that I don't know uml, so I tried to make my diagram through modifications of given samples in the yuml website. But I wasn't able to combine the two geometric shapes that I wish simultaneously. That's because a rectangular box is available in the Class Diagram Samples and the oval shape is available in the Use Case Diagram. But both doesn't work simultaneously in any of the two kinds of diagrams Example: (Register)>(Confirm Registration) is in the "Use case diagram" and [Customer]->[Billing Address] is in the "draw class diagram"