databaseentity-relationshipeer-model

Extended Entity-Relationship Model to tables (subclasses)


In the EER model there are subclasses entities. I was wondering what's the way to implement that in a real SQL Table or if there is any guide that might help me out to understand how to implement entities subclasses into tables that would help. Thanks


Solution

  • Martin Fowler's book Patterns of Enterprise Application Architecture covers solutions for subclassing tables:

    These correspond to the options in the answer from @spencer7593, without being tied to Java & Hibernate.