Attach / Remove Items with EAV Table

Question

I have a table like below that will have a product description

╔════╦══════════════╦═════╗
║ Id ║ name ║ price║
╠════╬══════════════╬═════╣
║ 1 ║ Apple ║ 23 ║
║ 2 ║ shirt ║ 148 ║
║ 3 ║ computer ║ 101 ║
║ 4 ║ printer ║ 959 ║
╚════╩══════════════╩═════╝

and another table that stores the attributes associated with the identifier

╔════╦══════════════╦═════╗
║ Id ║ attr_name ║ Value║
╠════╬══════════════╬═════╣
║ 1 ║ color ║ red ║
║ 1 ║ size ║ xl ║
║ 1 ║ brand ║ App ║
║ 2 ║ color ║ blue
║ 2 ║ size ║ l ║
║ 3 ║ color ║ blue
║ 3 ║ size ║ xxl ║
║ 3 ║ brand ║ HP ║
╚════╩══════════════╩═════╝

Is there any possible way to bring the table as shown below if I know that the attribute name will only be color size and brand

╔════╦══════════╦════════════════╦═══════╗
║ id ║ name ║ color ║ brand ║ size ║ ║
╠════╬══════════╬═══════╬═══════╬══════╬══╣
║ 1 ║  ║  ║  ║ xl ║ ║
║ 2 ║  ║  ║ ║ l ║ ║
║ 3 ║  ║  ║ HP ║ XXL ║ ║
║ 4 ║  ║ ║ ║ ║ ║
╚════╩══════════╩═══════╩═══════╩══════╩══╝

Answer 1

CASE :

select d.id,
  d.name,
  max(case when a.attr_name = 'color' then a.value end) color,
  max(case when a.attr_name = 'brand' then a.value end) brand,
  max(case when a.attr_name = 'size' then a.value end) size
from product_description d
inner join product_attributes a
  on d.id = a.id
group by d.id, d.name;

SQL Fiddle with Demo.

Oracle 11g, PIVOT :

select id, name, Color, Brand, "Size"
from
(
  select d.id, d.name,
    a.attr_name, a.value
  from product_description d
  inner join product_attributes a
    on d.id = a.id
) src
pivot
(
  max(value)
  for attr_name in ('color' as Color,
                    'brand' as Brand,
                    'size' as "Size")
) p;

. SQL Fiddle with Demo