Terminology
  
    base table:
                entity    attribute    value
                --------- ------------ -----------
                1         A             x
                1         B             y
                1         C             z
                2         A             p
                2         B             d
                2         C             q
  
    pivot table:
                entity    A   B   C
                --------- --- --- ---
                1         x   y   z
                2         p   d   q
  
  Composite primary key of base table: entity+attribute
  Entity-Attribute-Value (EAV) model