Eugene Elutin (9/11/2012)Actually the attribute splitting may not be a flaw, but done on purpose. One of the common places where you can see this kind of picture is data warehouses (non-conformed dimensions).

Or companies that vend solutions to multiple customers and can't mix their data for legal reasons. Like health insurance software companies that host the data on site. I actually worked for one of those.

Of course, in that instance, any request to mingle the data via UNION (at least in the U.S.) would be a Bad Idea.