Functional dependency between i_brand_id and brand does not hold

[wqsahmed]

In the item table, for all current records (where i_rec_end_date is NULL) each unique value for column i_brand_id does not point to only only 1 brand name. In other words, the brand name cannot be determined from the brand id itself. Same is the case with class_id and class columns. Even if it is the way it was meant to be, isn't it semantically incorrect?

Another issue is that the hierarchy item->brand->class-> category does not exist in the generated data.