Database Design - Supertypes and Subtypes
 

I'm designing a database and I'm not sure if the way I'm doing it is best. I attached a snippet of my ER diagram to this post.

I'm most concerned with the subtype relationships (Datasets to production datasets, Datasets to delivery_datasets, etc…). I’ve created a database with the design in the diagram and it seems like some queries are more difficult to write than they should be. Would anyone mind taking a look at the design and letting me know if I’m on the right track.

Thanks a lot!