denormalize view 1