Curious if anybody has tried to address data normalization with the use of Relationship fields. For example, imagine a data set of chess players where we track information about them (age, rating, title if any) and their games. Most players don’t have a title, like Grandmaster, National Master, etc. If I create a field to capture this data for those who do, most of the time this field will be blank. I could use conditional logic to determine whether to show the field or not on the Admin screen, but regardless the empty field would still exist.
As the database grows and imagining much more complex data sets, this could be a problem. I could create multiple custom post types with their own data fields and then use a relationship field to connect data as needed. Any thoughts?
