How should we model entity subtypes in a relational DBMS? In other words – how do we model inheritance in a relational database system? This is a question I’ve come across many times, but I never felt like I had the perfect answer. These are some of the solutions I’ve encountered: Separate tables Single, sparse… Continue reading Inheritance in entity-relationship modelling