create view file_denormalized as
 select a.id, a.name, a.size, a.mimetype,
    b.playlength, b.artist,
    c.width, c.height
 from file a, mp3_properties b, image_properties c