Explore the concepts of supertypes and subtypes in database design, including how inheritance works in data modeling.